User-defined function: Difference between revisions

Revision as of 15:00, 24 May 2021

Revision as of 18:56, 30 August 2021

Line 14:

</syntaxhighlight>

Once created, a user-defined function may be used in [[expression (programming)|expressions]] in SQL statements. For example, it can be invoked where most other intrinsic functions are allowed. This also includes [[Select (SQL)|SELECT statements]], where the function can be used against data stored in tables in the database. Conceptually, the function is evaluated once per row in such usage. For example, assume a table named ELEMENTS{{Code|Elements}}, with a row for each known chemical element. The table has a column named BoilingPoint for the boiling point of that element, in Celsius. The query

<syntaxhighlight lang="sql">