Here is a short example where this touchy bug
occurs :
create database mydb;
\c mydb
create table temp ( name varchar(12));
insert into temp values ('eric');
insert into temp values ('daniel');
insert into temp values ('ernst');
insert into temp values ('chantal');
having the four names abo
[EMAIL PROTECTED] writes:
> select name from temp where name like 'e%'
> union
> select name from temp where name not like 'e%'
> order by substr(name,1,4) asc;
This isn't supported. 7.1 knows that it can't do it:
regression=# select name from temp where name like 'e%'
regression-# union
regres
Eric Pare ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
order by using functions under unions
Long Description
When using union over queries, if the order by clause occurs using a function, the
output will not be correctly o
