mike <[EMAIL PROTECTED]> writes: > If I do the same query, except to create a new table, everything works, > so is this a view bug?
Possibly, but you haven't given enough info to let someone else reproduce the problem. A SQL script that creates all the necessary tables and the view and then triggers the failure would make it much easier for us to investigate. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html