Postgres Pro
Downloads
Home   >   mailing lists

Re: Sv: how to build this query ??? Please help !!! - Mailing list pgsql-sql

From Tom Lane
Subject Re: Sv: how to build this query ??? Please help !!!
Date
Msg-id 29568.979013354@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sv: how to build this query ??? Please help !!!  ("Robert B. Easter" <reaster@comptechnews.com>)
List pgsql-sql
Tree view 
"Robert B. Easter" <reaster@comptechnews.com> writes:
> -- this crashes
> select a, (SELECT b FROM y WHERE y.b = x.a + 1) AS b
>     FROM x WHERE a IN (SELECT b FROM y)
>     GROUP BY a,b
>     HAVING a IN (SELECT b FROM y WHERE b > 1);

Fixed.  'Twas another case of trying to close a subplan twice ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: hex number
Next
From: "Robert B. Easter"
Date:
Subject: subselect test