Rod Taylor wrote: > > For some reason a view with a select distinct, an order and an exception > by will cause pg_dump to output a double order by -- one for each select > which of course is bad SQL.
I think views should not have ORDER BY clauses at all in the first place. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])