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 true THEN 1
               ELSE 0
           END AS c, 1 AS d
      FROM dual;

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to