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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
