Re: multiple SRFs in SELECT clause.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: multiple SRFs in SELECT clause.
Date: 2006-11-27 18:48:25
Message-ID: 21812.1164653305@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Kris Jurka <books(at)ejurka(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Gilberto Xavier 2006-11-27 19:32:51 BUG #2786: PGADMIN 1.6
Previous Message Thomas H. 2006-11-27 18:04:38 Re: 8.2rc1: vacuum full fills up disk space