From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Subselect AS and Where clause |
Date: | 2011-01-26 08:20:28 |
Message-ID: | iholgb$usu$1@dough.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Uwe Schroeder, 26.01.2011 08:34:
> I have a query like this:
>
> SELECT a,b,c, (select problem from other_table where id=a) as problem FROM
> mytable WHERE a=1
>
> So far so good. Actually "problem" always resolves to one record, so it's not
> the "multiple records returned" problem.
>
> What I try to do is this:
>
> SELECT a,b,c, (select problem from other_table where id=a) as problem FROM
> mytable WHERE a=1 and problem = 3
>
> see the "problem=3" part in the where clause? The error I get is
>
> SQLError: (ProgrammingError) column "problem" does not exist
>
You need to wrap the whole SELECT in order to be able to use the column alias:
SELECT *
FROM (
SELECT a,
b,
c,
(select problem from other_table where id=a) as problem
FROM mytable
) t
WHERE a=1
AND problem = 3
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2011-01-26 08:21:01 | Re: Subselect AS and Where clause |
Previous Message | Guillaume Lelarge | 2011-01-26 08:06:36 | Re: Install Pgadmin3 1.12 on ubuntu 10.4 lucid client without postgresql server install |