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

From Tom Lane
Subject Re: INSERT ... VALUES... with ORDER BY / LIMIT
Date
Msg-id 742.1286118638@sss.pgh.pa.us
Whole thread Raw
In response to Re: INSERT ... VALUES... with ORDER BY / LIMIT  (Hitoshi Harada <umi.tanuki@gmail.com>)
Responses Re: INSERT ... VALUES... with ORDER BY / LIMIT
Re: INSERT ... VALUES... with ORDER BY / LIMIT
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tomoaki Sato
Date:
Subject: pgadmin3_90 package
Next
From: Tom Lane
Date:
Subject: Re: Heads up: upcoming back-branch releases