From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Marko Tiikkaja <marko(at)joh(dot)to> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <stark(at)mit(dot)edu>, Bruce Momjian <bruce(at)momjian(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_get_viewdefs() indentation considered harmful |
Date: | 2014-05-03 13:44:34 |
Message-ID: | 5364F2C2.4010404@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 05/03/2014 09:17 AM, Marko Tiikkaja wrote:
> Hi all,
>
> Now that we're on the topic of view deparsing, what are your thoughts
> on making this less painful?
>
> local:marko=#* create view foov as select exists(select * from foo);
> CREATE VIEW
> local:marko=#* \d+ foov
> View "public.foov"
> Column | Type | Modifiers | Storage | Description
> --------+---------+-----------+---------+-------------
> exists | boolean | | plain |
> View definition:
> SELECT (EXISTS ( SELECT foo.way,
> foo.too,
> foo.many,
> foo.columns,
> foo.here
> FROM foo)) AS "exists";
>
>
> I've switched to using SELECT 1 in EXISTS for this reason, but perhaps
> other people haven't yet done that..
>
>
>
I've done that for quite a few years. I think it's better style than
using *.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Krauss | 2014-05-03 13:55:18 | need of anonymous record |
Previous Message | Marko Tiikkaja | 2014-05-03 13:17:38 | Re: pg_get_viewdefs() indentation considered harmful |