Re: INSERT ... VALUES... with ORDER BY / LIMIT - Mailing list pgsql-hackers

From Robert Haas
Subject Re: INSERT ... VALUES... with ORDER BY / LIMIT
Date
Msg-id CCE2F56E-FBB5-430A-873B-E440A71D7CAF@gmail.com
Whole thread Raw
In response to Re: INSERT ... VALUES... with ORDER BY / LIMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Oct 3, 2010, at 11:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hitoshi Harada <umi.tanuki@gmail.com> writes:
>> DEFAULT is disallowed now in such VALUES list, but we can explain it
>> is allowed in a "simple" VALUES of INSERT case.
> 
> I don't think we really need to explain anything.  This is per spec;
> if you trace the way that a DEFAULT expression can appear in INSERT,
> it's treated as a <contextually typed value specification>,
> which appears in <contextually typed table value constructor>,
> which is VALUES and nothing else.

I thought we were discussing what should go into OUR documentation.

...Robert


pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: INSERT ... VALUES... with ORDER BY / LIMIT
Next
From: Robert Haas
Date:
Subject: Re: patch: tsearch - some memory diet