From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
---|---|
To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: updated hstore patch |
Date: | 2009-09-22 00:13:48 |
Message-ID: | E46ABF85-44D0-422D-A327-B4B1E1FAE895@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sep 21, 2009, at 4:57 PM, Andrew Gierth wrote:
> I don't think there's any way to do that from the regression tests.
The output that you demonstrated a few messages back should do nicely
for delete(), at least:
contrib_regression=# explain verbose select delete(('a' =>
now()::text),'a');
QUERY PLAN
-----------------------------------------------------------
Result (cost=0.00..0.02 rows=1 width=0)
Output: delete(('a'::text => (now())::text), 'a'::text)
(2 rows)
contrib_regression=# explain verbose select delete(('a' =>
now()::text),'a=>1'::hstore);
QUERY PLAN
--------------------------------------------------------------------
Result (cost=0.00..0.02 rows=1 width=0)
Output: delete(('a'::text => (now())::text), '"a"=>"1"'::hstore)
(2 rows)
Best,
David
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-22 01:09:14 | Re: updated hstore patch |
Previous Message | Andrew Gierth | 2009-09-21 23:57:42 | Re: updated hstore patch |