Robert Haas <robertmh...@gmail.com> writes: > Apparently Sybase and Microsoft SQL server use a slightly different > syntax, CROSS APPLY, for this.
> http://iablog.sybase.com/paulley/2008/07/cross-and-outer-apply/ Well, this is only a blog entry and not their manual, but AFAICT that is just a useless deviation from SQL-standard syntax; it does nothing that "CROSS JOIN LATERAL" or "LEFT JOIN LATERAL ... ON true" wouldn't do. I can't tell if the blogger simply doesn't know that LATERAL can be used in a JOIN nest, or if that's actually a misfeature of the DBMS. I'm not in favor of duplicating this. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
