Am Mittwoch, 7. Mai 2008 schrieb Eugen.Konkov@aldec.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.

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