[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
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> I'm not sure that tm_isdst == -1 is a legitimate indicator for mktime()
> failure on all platforms; it indicates "don't know", but afaik there is
> no defined behavior for the rest of the fields in that case. Can we be
> assured that for all platforms
