Re: query with =ALL - Mailing list pgsql-sql

From Richard Huxton
Subject Re: query with =ALL
Date
Msg-id 40CDE4D9.2010604@archonet.com
Whole thread Raw
In response to query with =ALL  ("Jaime Casanova" <el_vigia_ec@hotmail.com>)
List pgsql-sql
Jaime Casanova wrote:
> Hi all,
> 
> i have an strange result here, i'm using 7.4.2 on redhat 8
> 
> i have a query like this

[snip]

> this query proves that its result is 'A', 'B', 'C'
> any idea, is something wrong in my thinking?

Do you have any null values involved? That might well interfere (though 
I admit I haven't looked in detail)

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: query with =ALL
Next
From: "Jaime Casanova"
Date:
Subject: Re: query with =ALL