mike <mike(at)bristolreccc(dot)co(dot)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

In response to

• Re: Invalid input for integer on VIEW at 2004-08-24 15:40:25 from mike

Responses

• Re: Invalid input for integer on VIEW at 2004-08-24 17:42:52 from mike

pgsql-general by date

Next:	From: Silvio Matthes	Date: 2004-08-24 16:33:50
	Subject: WG: Re: Re: select ... where <column>='' does a seqscan [auf Viren geprueft]
Previous:	From: Ron St-Pierre	Date: 2004-08-24 16:28:15
	Subject: Re: Dump and Restore