Re: updated hstore patch - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: updated hstore patch
Date
Msg-id E46ABF85-44D0-422D-A327-B4B1E1FAE895@kineticode.com
Whole thread Raw
In response to Re: updated hstore patch  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: updated hstore patch
List 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


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: updated hstore patch
Next
From: Tom Lane
Date:
Subject: Re: updated hstore patch