Re: multiple SRFs in SELECT clause. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: multiple SRFs in SELECT clause.
Date
Msg-id 21812.1164653305@sss.pgh.pa.us
Whole thread Raw
In response to multiple SRFs in SELECT clause.  (Kris Jurka <books@ejurka.com>)
List pgsql-bugs
Kris Jurka <books@ejurka.com> writes:
> I'm getting some odd results when running two generate_series calls in a
> SELECT ...
> When the row counts differ you get the least common multiple number of
> rows.

Yup, this is the expected or at least historical behavior.  It's not
entirely clear what you *should* get, which is one reason we ought to
deprecate SRFs in SELECT lists.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Thomas H."
Date:
Subject: Re: 8.2rc1: vacuum full fills up disk space
Next
From: Ron Mayer
Date:
Subject: Re: Unexpected sort order (suspected bug)