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

Re: [HACKERS] Little Suggestion for 6.6

From: Daniele Orlandi <daniele(at)orlandi(dot)com>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] Little Suggestion for 6.6
Date: 1999-06-30 00:24:38
Message-ID: 377963C6.867C4640@orlandi.com (view raw or flat)
Thread:
Lists: pgsql-hackers

The Hermit Hacker wrote:
> 
> > 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?

IMHO it's the same, since they have to be equal...

Pardon me if I'm not seeing something obvious :^)

Bye.

-- 
 Daniele

-------------------------------------------------------------------------------
 Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
 Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------

In response to

Responses

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 1999-06-30 00:36:37
Subject: RE: [HACKERS] 6.5.1 status
Previous:From: Don BaccusDate: 1999-06-30 00:24:36
Subject: Re: [HACKERS] Little Suggestion for 6.6

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