The WITH ORDINALITY
clause can be used with set functions in the FROM
clause of a query.
ordinality
.
See Set-returning functions for a list of supported set functions.
Here is a simple example of how the WITH ORDINALITY
clause works.
t
like so:
unnest
function on the column arr
, call WITH ORDINALITY
, and rename the newly generated columns.