Re: [HACKERS] ORDER BY and UNION

Michael Fork <[EMAIL PROTECTED]> writes: > However, if I execute the same query and drop "a.attnum as number" from > the select part, it returns the following: > ... > which is incorrect accoring to the initial query. It appears to be > ordering the individual selects and then appending the secon

[HACKERS] ORDER BY and UNION

Is the following expected behavior for a UNION query with ORDER BY: executing this query: +++ SELECT a.attnum as number, a.attname as attribute, CASE WHEN t.typname = 'varchar' THEN t.typname || '(' || a.atttypmod - 4