Re: pretty print viewdefs

Tom Lane wrote:
>> I assume you are in effect saying you don't mind if there is an 
>> occasional blank line in the output.
>>     
>
> What blank line?  I would expect prettyprinting of expressions to
> sometimes insert an embedded newline, but not one at the beginning
> or end.  Do you have a counterexample?
>
>             
>   

Yes, CASE expressions, as in my previously posted example:
    SELECT 'a'::text AS b, ( SELECT 1              FROM dual) AS x, random() AS y,           CASE               WHEN
trueTHEN 1               ELSE 0           END AS c, 1 AS d      FROM dual;
 

cheers

andrew