Tom,
thanks for your input. Now I have something to bash my
programmers over the head with ;-)
No, just kidding... But as you say, it is plain bad SQL, I
realize this fully now. Oddly enough, I have a SQL book that
has one or two examples with order by a.foobar. Oh well...
Thanks for the prompt
Hi!
I'm not certain this is correct SQL, and I know the rewrite is
easy, but here is a difference I found between 7.0.3 and 7.1:
select a.name from users a
union
select a.name from oldusers a
order by a.userid;
ERROR: Relation 'a' does not exist
This works fine in postgres 7.0.x
the simple
[EMAIL PROTECTED] writes:
> I'm not certain this is correct SQL, and I know the rewrite is
> easy, but here is a difference I found between 7.0.3 and 7.1:
> select a.name from users a
> union
> select a.name from oldusers a
> order by a.userid;
> ERROR: Relation 'a' does not exist
It's not co
Palle Girgensohn ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
select a.name ... union select a.name ... order by a.name fails in 7.1
Long Description
Hi!
I'm not certain this is correct SQL, and I know the rewrite is
easy,
