Re: pg_get_viewdefs() indentation considered harmful
| От | Marko Tiikkaja |
|---|---|
| Тема | Re: pg_get_viewdefs() indentation considered harmful |
| Дата | |
| Msg-id | 5364EC72.7050202@joh.to обсуждение исходный текст |
| Ответ на | Re: pg_get_viewdefs() indentation considered harmful (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: pg_get_viewdefs() indentation considered harmful
|
| Список | pgsql-hackers |
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..
Regards,
Marko Tiikkaja
В списке pgsql-hackers по дате отправления: