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.