| From: | daveg <daveg(at)sonic(dot)net> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David E(dot) Wheeler" <david(at)kineticode(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Adding \ev view editor? |
| Date: | 2009-09-23 22:04:20 |
| Message-ID: | 20090923220419.GB27227@sonic.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sonic(dot)net 510 536 1443 510 282 0869
If simplicity worked, the world would be overrun with insects.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stef Walter | 2009-09-23 23:06:18 | Re: pg_hba.conf: samehost and samenet [REVIEW] |
| Previous Message | Mark Mielke | 2009-09-23 21:49:55 | Re: pg_hba.conf: samehost and samenet [REVIEW] |