Ian Morgan <[EMAIL PROTECTED]> writes: > Even if adding ORDER BY to a UNION is really sub-optimal SQL, shouldn't > pg_dump (and even psql's \d <viewname>) produce SQL that actually > works
I didn't say it wasn't a bug ;-) ... just pointing out that fixing it doesn't seem very high priority. I'll do something about it next time I have occasion to touch ruleutils.c. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly