On Thu, 14 Mar 2002, Tom Lane wrote:
> Vince Vielhaber <vev@michvhf.com> writes:
> >> What's your definition of "other dbs"? The above statement is quite
> >> clearly in violation of the SQL92 and SQL99 specifications:
>
> > And nowhere does it say that <column name> cannot be qualified with
> > the table name in front of it.
>
> Au contraire, that is EXACTLY what that bit of BNF is saying. If
> they'd meant to allow this construction then the BNF would refer to
> <qualified name>, not just <identifier>.
>
> > Looking at the entire message noted
> > above the list of other dbs that support it is now Oracle, Sybase,
> > MS-SQL and mysql. If "other dbs" ends up the equivilent of "everything
> > but PostgreSQL" then which one is non-standard?
>
> Out of curiosity, what do these guys do if I try the obvious
>
> insert into foo (bar.col) ...
Looks like Sybase ignores the bar:
1> create table foo(a int)
2> go
1> insert into foo(bar.a) values(1)
2> go
(1 row affected)
1> select * from foo
2> goa----------- 1
(1 row affected)
1>
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo
atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================