On Wed, Aug 22, 2012 at 8:04 AM, Tom Lane <[email protected]> wrote: > Chris Travers <[email protected]> writes: >> It's when we add group by that things appear broken. Note it starts >> returning 196 (14 x 14) records, which suggests a cross join against >> itself. > >> mtech_test=# explain analyze select (account_heading__list()).* group by >> accno >> mtech_test-# ; > > Hm, that really ought to throw an error, since you have ungrouped > columns in the result. Not sure why it doesn't.
Yeah, that was my point. I don't know if it is worth fixing but always better to report. > > Beyond that, though, using a SRF in the target list this way is a bad > idea because the semantics are very ill-defined. Yeah. It looks like when you pair it with a general set in a from clause you get an implicit cross join. I have been avoiding it because I don't like implicit cross joins. I will be following the LATERAL feature with interest. Thanks for that. Best Wishes, Chris Travers -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
