mike <mike@bristolreccc.co.uk> 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