X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 66618D1B1C8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 14 Jun 2004 16:53:44 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 04394-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 14 Jun 2004 19:53:41 +0000 (GMT)
Received: from hotmail.com (bay8-f43.bay8.hotmail.com [64.4.27.43])
	by svr1.postgresql.org (Postfix) with ESMTP id 51007D1B1BC
	for <pgsql-sql@postgresql.org>; Mon, 14 Jun 2004 16:53:38 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Mon, 14 Jun 2004 12:53:41 -0700
Received: from 69.65.137.210 by by8fd.bay8.hotmail.msn.com with HTTP;
	Mon, 14 Jun 2004 19:53:41 GMT
X-Originating-IP: [69.65.137.210]
X-Originating-Email: [el_vigia_ec@hotmail.com]
X-Sender: el_vigia_ec@hotmail.com
From: "Jaime Casanova" <el_vigia_ec@hotmail.com>
To: tgl@sss.pgh.pa.us
Cc: pgsql-sql@postgresql.org
Subject: Re: query with =ALL
Date: Mon, 14 Jun 2004 19:53:41 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <BAY8-F43IO1PH5phq9d0003307c@hotmail.com>
X-OriginalArrivalTime: 14 Jun 2004 19:53:41.0993 (UTC)
	FILETIME=[4B239590:01C45249]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200406/125
X-Sequence-Number: 18070

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