Re: Adding \ev view editor? - Mailing list pgsql-hackers

On Mon, Sep 21, 2009 at 02:26:05PM -0400, Andrew Dunstan wrote:
>    andrew=# select pg_get_viewdef('foo',true);
>            pg_get_viewdef       
>    ------------------------------
>      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;
>    (1 row)

+1 

-dg


-- 
David Gould       daveg@sonic.net      510 536 1443    510 282 0869
If simplicity worked, the world would be overrun with insects.