Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG: aliases does not work ((
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: pgsql-bugs(at)postgresql(dot)org
- Cc: Eugen(dot)Konkov(at)aldec(dot)com
- Subject: Re: BUG: aliases does not work ((
- Date: Wed, 7 May 2008 13:52:37 +0200
- Message-id: <200805071352(dot)37691(dot)peter_e(at)gmx(dot)net>
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.
- Follow-Ups:
- Re: BUG: aliases does not work ((
- From: Eugen.Konkov
- Re: BUG: aliases does not work ((
- References:
- BUG: aliases does not work ((
- From: Eugen.Konkov
- BUG: aliases does not work ((
- Prev by Date: BUG: aliases does not work ((
- Next by Date: ORDER BY...LIMIT optimization does not work with inherited tables
- Previous by thread: BUG: aliases does not work ((
- Next by thread: Re: BUG: aliases does not work ((
- Indexes: