Re: insert statements - Mailing list pgsql-hackers

Out of curiosity, does SyBase allow you to qualify it with
schema.table.column?
--
Rod Taylor

This message represents the official view of the voices in my head

----- Original Message -----
From: "Vince Vielhaber" <vev@michvhf.com>
To: "Rod Taylor" <rbt@zort.ca>
Cc: "Peter Eisentraut" <peter_e@gmx.net>;
<pgsql-hackers@postgreSQL.org>
Sent: Thursday, March 14, 2002 9:39 AM
Subject: Re: [HACKERS] insert statements


> On Thu, 14 Mar 2002, Rod Taylor wrote:
>
> >  As snipped from:
> > http://archives.postgresql.org/pgsql-bugs/2000-10/msg00030.php
(All
> > my stuff is in paper form)
> > 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.  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?
>
>
>
>
> >
> >           <insert statement> ::=
> >                INSERT INTO <table name>
> >                  <insert columns and source>
> >
> >           <insert columns and source> ::=
> >                  [ <left paren> <insert column list> <right
paren> ]
> >                <query expression>
> >                | DEFAULT VALUES
> >
> >           <insert column list> ::= <column name list>
> >
> >           <column name list> ::=
> >                <column name> [ { <comma> <column name> }... ]
> >
> >           <column name> ::= <identifier>
> >
> > I'm not particularly excited about supporting non-SQL variant
syntaxes
> > that add no functionality.
> >
> > regards, tom lane
> > --
> > Rod Taylor
> >
> > This message represents the official view of the voices in my head
> >
> > ----- Original Message -----
> > From: "Vince Vielhaber" <vev@michvhf.com>
> > To: "Rod Taylor" <rbt@zort.ca>
> > Cc: "Peter Eisentraut" <peter_e@gmx.net>;
> > <pgsql-hackers@postgreSQL.org>
> > Sent: Thursday, March 14, 2002 9:08 AM
> > Subject: Re: [HACKERS] insert statements
> >
> >
> > > On Thu, 14 Mar 2002, Rod Taylor wrote:
> > >
> > > > Why not send in your changes to PostNuke along with the
> > appropriate
> > > > section from the SQL specs?
> > > >
> > > > Surely they'll apply a reasoned patch which improves
conformance
> > to
> > > > the SQL standard and doesn't break anything in the process.
I'd
> > > > suspect both SyBase, and MySQL can also take insert into foo
(a)
> > as
> > > > well.
> > >
> > > Look below, I showed both syntaxes with Sybase.  Since I don't
have
> > a
> > > copy of the SQL specs I can't send them the appropriate section
or I
> > > would have already.  Care to forward that appropriate section?
> > >
> > >
> > > > --
> > > > Rod Taylor
> > > >
> > > > This message represents the official view of the voices in my
head
> > > >
> > > > ----- Original Message -----
> > > > From: "Vince Vielhaber" <vev@michvhf.com>
> > > > To: "Peter Eisentraut" <peter_e@gmx.net>
> > > > Cc: <pgsql-hackers@postgreSQL.org>
> > > > Sent: Thursday, March 14, 2002 8:29 AM
> > > > Subject: Re: [HACKERS] insert statements
> > > >
> > > >
> > > > > On Wed, 13 Mar 2002, Peter Eisentraut wrote:
> > > > >
> > > > > > Vince Vielhaber writes:
> > > > > >
> > > > > > > For example:
> > > > > > >
> > > > > > > insert into foo(foo.a) values(1);
> > > > > > >
> > > > > > > fails because the table name is used.  Update statements
> > also
> > > > include the
> > > > > > > table name.  Both fail.  Does anyone know of a
workaround?
> > > > > >
> > > > > > Completely loudly to whomever wrote that SQL.  It's
completely
> > > > > > non-standard.
> > > > > >
> > > > > > (The implication I'm trying to make is that there's no way
to
> > make
> > > > > > PostgreSQL accept that statement.  Adding this as an
extension
> > has
> > > > been
> > > > > > rejected in the past.)
> > > > >
> > > > > I'm now wondering why it was rejected.  I couldn't try this
last
> > > > nite
> > > > > so I just tried it now.  Here's with Sybase 11.0.3.3 :
> > > > >
> > > > > 1> create table foo(a int)
> > > > > 2> go
> > > > > 1> insert into foo(a) values(1)
> > > > > 2> go
> > > > > (1 row affected)
> > > > > 1> insert into foo(foo.a) values(2)
> > > > > 2> go
> > > > > (1 row affected)
> > > > > 1>
> > > > >
> > > > > And I suspect more than just mysql and sybase accept either
> > syntax.
> > > > > Right now I'm modifying postnuke but that's only a short
term
> > > > solution,
> > > > > and I wouldn't want to add it to PostgreSQL either 'cuze if
it
> > > > remains
> > > > > rejected that would hamper upgrades.  ROCK --> ME <-- HARD
PLACE
> > > > :)
> > > > > There are really no other decent CMSs available that support
> > > > PostgreSQL.
> > > > >
> > > > > Vince.
> > > > > --
> > > > >
> > > >
> >
======================================================================
> > > > ====
> > > > > Vince Vielhaber -- KA8CSH    email: vev@michvhf.com
> > > > http://www.pop4.net
> > > > >          56K Nationwide Dialup from $16.00/mo at Pop4
Networking
> > > > >         Online Campground Directory
> > http://www.camping-usa.com
> > > > >        Online Giftshop Superstore
> > http://www.cloudninegifts.com
> > > > >
> > > >
> >
======================================================================
> > > > ====
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > > TIP 6: Have you searched our list archives?
> > > > >
> > > > > http://archives.postgresql.org
> > > > >
> > > >
> > > >
> > >
> > >
> > > Vince.
> > > --
> > >
> >
======================================================================
> > ====
> > > Vince Vielhaber -- KA8CSH    email: vev@michvhf.com
> > http://www.pop4.net
> > >          56K Nationwide Dialup from $16.00/mo at Pop4 Networking
> > >         Online Campground Directory
http://www.camping-usa.com
> > >        Online Giftshop Superstore
http://www.cloudninegifts.com
> > >
> >
======================================================================
> > ====
> > >
> > >
> > >
> > >
> >
> >
>
>
> Vince.
> --
>
======================================================================
====
> Vince Vielhaber -- KA8CSH    email: vev@michvhf.com
http://www.pop4.net
>          56K Nationwide Dialup from $16.00/mo at Pop4 Networking
>         Online Campground Directory    http://www.camping-usa.com
>        Online Giftshop Superstore    http://www.cloudninegifts.com
>
======================================================================
====
>
>
>
>