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 (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
