Re: row literal problem - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: row literal problem
Date
Msg-id CAHyXU0ywPPKEcppvJt+WWRn_rkfm6Wz3r4id-+snvGURRhbfFA@mail.gmail.com
Whole thread Raw
In response to Re: row literal problem  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: row literal problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Jul 18, 2012 at 3:56 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> hm, it's the 'group by' -- for example if you add group by
> pg_namespace.oid, group by pg_namespace.oid || 'abc', you can invent
> columns that come back into the rowtype.

here's a cut down example:
with q as (select max(v) from (select 1 as v) q group by v) select q from q;

merlin


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: row literal problem
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] DELETE vs TRUNCATE explanation