| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, decibel <decibel(at)decibel(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pretty print viewdefs |
| Date: | 2009-08-27 18:37:02 |
| Message-ID: | 4A96D24E.6040201@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Wultsch | 2009-08-27 18:39:22 | Re: MySQL Compatibility WAS: 8.5 release timetable, again |
| Previous Message | Tom Lane | 2009-08-27 18:17:22 | Re: pretty print viewdefs |