Re: using schema-qualified names in INSERTs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John D(dot) Burger" <john(at)mitre(dot)org>
Cc: PostgreSQL-general general <pgsql-general(at)postgresql(dot)org>
Subject: Re: using schema-qualified names in INSERTs
Date: 2006-02-13 16:34:35
Message-ID: 2037.1139848475@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"John D. Burger" <john(at)mitre(dot)org> writes:
> Arguably a tad inconsistent. I don't know what the OP's rationale was,
> but I can imagine that allowing the syntax on INSERT might simplify the
> generation of SQL in certain circumstances. There's also the Principle
> of Least Surprise, etc.

There's also something called the SQL standard, which forbids both of
those syntaxes.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2006-02-13 16:57:42 Re: using schema-qualified names in INSERTs
Previous Message Ken Winter 2006-02-13 16:19:12 Re: Why does an ON SELECT rule have to be named "_RETURN"?