Re: calling a function that takes a row type and returns a set of rows

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Le 11 oct. 08 à 08:18, Pavel Stehule a écrit :
>> I'm not sure about the syntax, but LATERAL is a standard JOIN type
>> wherein
>> upper "nodes" are visible.

> no, this strange syntax is far to any standard. Solution is using
> dynamic cursor ala DB2 (that isn't supported in postgres) - select *
> from fce(cursor(select .... from tab))

Yes it's standard notation. SQL2008 has it in Foundation document, see
its grammar reference at page 343 of my PDF reader, labelled page 321
(Query Expressions):

7.6 <table reference>
<table primary> ::=
...
| <lateral derived table> [ AS ] <correlation name>
[ <left paren><derived column list><right paren> ]
...

<lateral derived table> ::=
LATERAL<table subquery>

You'll find out more from http://wiscorp.com/SQLStandards.html

Regards,
- --
dim

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkjxByYACgkQlBXRlnbh1blh8wCeNpirQ5902oVgH8Xh8rhYr3qF
rOMAn1opkDflbRn9PPuD1fmMGblLvzgQ
=7wSp
-----END PGP SIGNATURE-----