Vince Vielhaber <vev@michvhf.com> writes:
> On Fri, 15 Mar 2002, Thomas Lockhart wrote:
>> But I *really* don't see the benefit of that <table>(<table>.<col>)
>> syntax. Especially when it cannot (?? we need a counterexample) lead to
>> any additional interesting beneficial behavior.

> The only benefit I can come up with is existing stuff written under
> the impression that it's acceptable.

That's the only benefit I can see either --- but it's not negligible.
Especially not if the majority of other DBMSes will take this syntax.

I was originally against adding any such thing, but I'm starting to
lean in the other direction.

I'd want it to error out on "INSERT foo (bar.col)", though ;-)

			regards, tom lane

Fri, 15 Mar 2002 15:06:45 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: insert statements 
On Fri, 15 Mar 2002, Tom Lane wrote:

> Vince Vielhaber <vev@michvhf.com> writes:
> > On Fri, 15 Mar 2002, Thomas Lockhart wrote:
> >> But I *really* don't see the benefit of that <table>(<table>.<col>)
> >> syntax. Especially when it cannot (?? we need a counterexample) lead to
> >> any additional interesting beneficial behavior.
>
> > The only benefit I can come up with is existing stuff written under
> > the impression that it's acceptable.
>
> That's the only benefit I can see either --- but it's not negligible.
> Especially not if the majority of other DBMSes will take this syntax.
>
> I was originally against adding any such thing, but I'm starting to
> lean in the other direction.
>
> I'd want it to error out on "INSERT foo (bar.col)", though ;-)

So would I.

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
==========================================================================




Sun, 17 Mar 2002 22:36:54 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: insert statements 
Tom Lane wrote:
> 
> I'd want it to error out on "INSERT foo (bar.col)", though ;-)
> 

And on "INSERT foo (bar.foo.col)" as well.

This means we will have to take this check down to the analyze
phase (where the schema where foo is located is finally known,
if it was not specified explicitly).

We could easily take "INSERT bar.foo (bar.foo.col)" but the
above one is trouble.

-- 
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9

Mon, 18 Mar 2002 11:58:23 -0500
Fernando Nasser <fnasser@redhat.com>
Re: insert statements