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

Re: Bug or expected behaviour

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Ravinder Bhalla <Ravinder(dot)Bhalla(at)ipix(dot)com>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: Bug or expected behaviour
Date: 2003-12-16 01:23:26
Message-ID: 20031215172132.C97064@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: sfpug
On Mon, 15 Dec 2003, Ravinder Bhalla wrote:

> Does that mean
>
> Both the following query will throw same result (assuming empname aslo exist
> in Dept)
>
> select * from emp where empid in ( select empname from dept);

I think this is effectively the same as:
 select * from emp where empid=empname and exists(select 1 from dept)

> select * from emp where empid in ( select empid from dept) ;
And this one would be:
 select * from emp where empid=empid and exists(select 1 from dept)

In response to

sfpug by date

Next:From: David AlbanDate: 2003-12-16 02:25:45
Subject: SIG-BEER-WEST this Saturday 8/16 in San Francisco
Previous:From: Ravinder BhallaDate: 2003-12-15 22:35:37
Subject: Re: Bug or expected behaviour

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