Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> writes:
> The view itself works, so it must be the pretty 
> printer that is broken (where ever that is hidden away in the code).

Yeah, I think this is due to overenthusiastic removal of parentheses.
I believe if you pg_dump the view you will get a correctly parenthesized
version, because pg_dump does not trust the pretty printer (for reasons
that should now be obvious...)

			regards, tom lane

In response to

• Re: Bug with view definitions? at 2004-07-01 13:19:32 from Dennis Bjorklund

pgsql-hackers by date

Next:	From: Bruno Wolff III	Date: 2004-07-01 17:23:10
	Subject: Re: Adding column comment to information_schema.columns
Previous:	From: Dennis Bjorklund	Date: 2004-07-01 17:07:31
	Subject: Re: Adding column comment to information_schema.columns