| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Dean Rasheed <dean_rasheed(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: No error when column doesn't exist |
| Date: | 2008-09-11 15:21:53 |
| Message-ID: | 48C93791.8040105@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2008-09-11 15:36:39 | Re: psql scripting tutorials |
| Previous Message | Tomasz Ostrowski | 2008-09-11 15:21:16 | Re: Autocommit, isolation level, and vacuum behavior |