Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Little Suggestion for 6.6

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: The Hermit Hacker <scrappy(at)hub(dot)org>, Daniele Orlandi <daniele(at)orlandi(dot)com>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] Little Suggestion for 6.6
Date: 1999-06-30 00:24:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
At 08:56 PM 6/29/99 -0300, The Hermit Hacker wrote:
>On Wed, 30 Jun 1999, Daniele Orlandi wrote:
>> I don't know what SQL standards say about this, but in:
>> tacacs=> SELECT * FROM users,counters WHERE
users.username=counters.username AND
>> username='foobar';
>> ERROR:  Column 'username' is ambiguous
>> ...username is NOT ambiguous...

>Of course it is...which username do you want to match on, users.username
>or counters.username?

He's saying that the expression can be resolved because 
their values are equal, so it doesn't matter which username
you match on. 

Which means he thinks that expression semantics rather than
scoping/parsing/type rules ought to determine what is
and what is not an ambiguous expression.  Which is...well...
just wrong :)

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
  Nature photos, on-line guides, and other goodies at

In response to

pgsql-hackers by date

Next:From: Daniele OrlandiDate: 1999-06-30 00:24:38
Subject: Re: [HACKERS] Little Suggestion for 6.6
Previous:From: Chris BitmeadDate: 1999-06-30 00:03:11
Subject: Re: [HACKERS] User requests now that 6.5 is out

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group