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: (view raw, whole thread or download thread mbox)
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,
>  from
>  where exists(select 1 from where =
>   and = 'Sheen');

Ah, that was exactly what I was looking for.

> select,
>  from
>  where in (select where = 'Sheen');


 where in (
   select from where = 'Sheen'

(missing FROM)

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

In response to


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-2017 The PostgreSQL Global Development Group