From: | "D'Arcy" "J(dot)M(dot)" Cain <darcy(at)druid(dot)net> |
---|---|
To: | Andreas(dot)Zeugswetter(at)telecom(dot)at (ZEUGSWETTER Andreas IZ5) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Open 6.5 items |
Date: | 1999-05-19 13:25:25 |
Message-ID: | m10k6Ld-0000bIC@druid.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thus spake ZEUGSWETTER Andreas IZ5
> > Allow "col AS name" to use name in WHERE clause? Is this ANSI?
> > Works in GROUP BY
> But it probably adds some complexity:
>
> create table a (a int, b int, c int);
> select a, b as c from a where c=5;
>
> Which c do you use alias or column ? You prbly need to use the column,
> since this is how all others work, but would this be intuitive ?
Not to me. What if I don't know that a c exists in the table, or it is
added after creating many scripts? I think we should use the alias in
that case. Either that or it should generate an error.
--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
From | Date | Subject | |
---|---|---|---|
Next Message | secret | 1999-05-19 13:46:52 | Re: [SQL] Oddities with NULL and GROUP BY |
Previous Message | Thomas Lockhart | 1999-05-19 13:06:24 | Re: [HACKERS] I thought this was picked up ages ago? |