Re: Playing with set returning functions in SELECT list - behaviour intended? - Mailing list pgsql-general

From Tom Lane
Subject Re: Playing with set returning functions in SELECT list - behaviour intended?
Date
Msg-id 13656.1245161214@sss.pgh.pa.us
Whole thread Raw
In response to Playing with set returning functions in SELECT list - behaviour intended?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: Playing with set returning functions in SELECT list - behaviour intended?
List pgsql-general
"Albe Laurenz" <laurenz.albe@wien.gv.at> writes:
> So it looks like the number of result rows is the least common multiple
> of the cardinalities of all columns in the select list.

It's always been that way.  The lack of any obviously-sane way to
handle multiple SRFs in a targetlist is exactly why the feature is
looked on with disfavor.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Trigger Function and backup
Next
From: Tom Lane
Date:
Subject: Re: pg_relation_size, relation does not exist