Re: BUG: aliases does not work ((

> Aliases in the select list are not in scope in the having clause.
it will be good if aliases will be in scope of 'having' clause.
Because of dublicating code is cause of bugs when people foget replace
code 
in second place while changing code in first one =(

----- Original Message ----- 
From: "Peter Eisentraut" <peter_e@[EMAIL PROTECTED]
>
To: <pgsql-bugs@[EMAIL PROTECTED]
>
Cc: <Eugen.Konkov@[EMAIL PROTECTED]
>
Sent: Wednesday, May 07, 2008 2:52 PM
Subject: Re: [BUGS] BUG: aliases does not work ((


> Am Mittwoch, 7. Mai 2008 schrieb Eugen.Konkov@[EMAIL PROTECTED]
>>  SELECT
>> MIN(COALESCE(cmp_values(parent_td.value, parent_md.value,
>> parent_cmp.value),0)) as chk_parent, FROM some_table
>>
>> having chk_parent > 0
>>
>> ERROR:  column "chk_parent" does not exist at character 2342
>
> Aliases in the select list are not in scope in the having clause. 
Either
> write out the expression again or use a subquery. 


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs