CREATE TEMP TABLE foo( bar integer );
SELECT 123 AS x
FROM foo
GROUP BY 1
HAVING x> AVG(bar)
causes
ERROR: column "x" does not exist
Why ? How to make this working ?
In real application I have long expression instead of 123 and do'nt want
repeat this expression in HAVING clause.
In VFP this select works OK.
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
