| From: | "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: query with =ALL |
| Date: | 2004-06-14 19:53:41 |
| Message-ID: | BAY8-F43IO1PH5phq9d0003307c@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all,
> > AND
> > CPA.cur_paralelo = ALL (SELECT cur_paralelo FROM aca_t_curso ...)
>
>Wait a second ... we are all overthinking the problem. The subselect
>returns three *different* values. It is not possible for any
>CPA.cur_paralelo values to be simultaneously equal to all three.
>So this test certainly fails at every row of CPA.
>
>Perhaps you meant "= ANY"?
Not really becuase ANY has the same efect that IN and what i want is all the
results that are equal in all the rows in any of the cur_paralelo values.
But must be in all the cur_paralelo or nothing.
thanx in advance,
Jaime Casanova
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-06-14 19:55:43 | Re: query with =ALL |
| Previous Message | Tom Lane | 2004-06-14 19:41:40 | Re: query with =ALL |