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(at)gmx(dot)net>
To: <pgsql-bugs(at)postgresql(dot)org>
Cc: <Eugen(dot)Konkov(at)aldec(dot)com>
Sent: Wednesday, May 07, 2008 2:52 PM
Subject: Re: [BUGS] BUG: aliases does not work ((

> Am Mittwoch, 7. Mai 2008 schrieb Eugen(dot)Konkov(at)aldec(dot)com:
>> 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.