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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to