Re: UNNEST with multiple args, and TABLE with multiple funcs - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: UNNEST with multiple args, and TABLE with multiple funcs
Date
Msg-id 87ob5ewlq5.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: UNNEST with multiple args, and TABLE with multiple funcs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: UNNEST with multiple args, and TABLE with multiple funcs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> and this would result in producing the array elements as a tableTom> column.  There is nothing in there about a
functionreturningTom> set.
 

In the spec, there is no such thing as a function returning a set of
rows in the sense that we use.

Functions can return arrays or multisets of simple or composite types,
but a multiset is a single value like an array (just with slightly
different semantics), not a set of rows. (And in particular it's not
ordered.)

-- 
Andrew (irc:RhodiumToad)



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] Store Extension Options
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Can we trust fsync?