Re: No error when column doesn't exist - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: No error when column doesn't exist
Date
Msg-id 48C93791.8040105@gmx.net
Whole thread Raw
In response to Re: No error when column doesn't exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> The ideas I had involved not considering the cast interpretation when
> the actual syntax is table.column and some-set-of-other-conditions.
> While this is certainly possible to implement, any variant of it will
> break the existing 100% equivalence of foo.bar and bar(foo); which
> seems to me to be a nice principle, though I grant you won't find it
> anywhere in the SQL standard.

I think if we say that functions can be used as table attributes, and
types can be used as (cast) functions, and tables are types, then we are
simply stuck with the current behavior.  Individually, these all make
sense, so you can't break that chain without some really complicated warts.

pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: Autocommit, isolation level, and vacuum behavior
Next
From: Peter Eisentraut
Date:
Subject: Re: psql scripting tutorials