Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

LATERAL WITH ORDINALITY - numbering sets

One of the neat little features that arrived at PostgreSQL 9.4 is the WITH ORDINALITY ANSI-SQL construct. What this construct does is to tack an additional column called ordinality as an additional column when you use a set returning function in the FROM part of an SQL Statement.


Continue reading "LATERAL WITH ORDINALITY - numbering sets"


This post first appeared on Postgres OnLine Journal, please read the originial post: here

Share the post

LATERAL WITH ORDINALITY - numbering sets

×

Subscribe to Postgres Online Journal

Get updates delivered right to your inbox!

Thank you for your subscription

×