Re: updated hstore patch

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