Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 27 Nov 2006 13:48:25 -0500
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
- References:
- multiple SRFs in SELECT clause.
- From: Kris Jurka
- multiple SRFs in SELECT clause.
- Prev by Date: Re: 8.2rc1: vacuum full fills up disk space
- Next by Date: BUG #2786: PGADMIN 1.6
- Previous by thread: multiple SRFs in SELECT clause.
- Next by thread: fsync and semctl errors with 8.1.5/win32
- Indexes: