Re: pg_get_viewdefs() indentation considered harmful

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