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" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, May 07, 2008 2:52 PM
Subject: Re: [BUGS] BUG: aliases does not work ((
Am Mittwoch, 7. Mai 2008 schrieb [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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
