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

Re: Existential quantifier

From: Dag-Erling Smørgrav <des(at)des(dot)no>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Existential quantifier
Date: 2009-10-09 23:54:21
Message-ID: 86vdiop1hu.fsf@ds4.des.no (view raw or flat)
Thread:
Lists: pgsql-sql
Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
> Not at all tested as I don't have access to my db right now, but I think
> something like one of these would work:
>
> select fs.film.title, fs.film.year
>  from fs.film
>  where exists(select 1 from fs.star where fs.film.id = fs.star.film
>   and fs.star.last = 'Sheen');

Ah, that was exactly what I was looking for.

> select fs.film.title, fs.film.year
>  from fs.film
>  where fs.film.id in (select fs.star.film where fs.star.last = 'Sheen');

ITYM

select fs.film.title, fs.film.year
 from fs.film
 where fs.film.id in (
   select fs.star.film from fs.star where fs.star.last = 'Sheen'
 );

(missing FROM)

DES
-- 
Dag-Erling Smørgrav - des(at)des(dot)no

In response to

Responses

pgsql-sql by date

Next:From: Stephan SzaboDate: 2009-10-10 00:26:20
Subject: Re: Existential quantifier
Previous:From: Dag-Erling SmørgravDate: 2009-10-09 23:48:27
Subject: Re: Existential quantifier

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