On 4/10/2013 11:01 AM, E E wrote:
CREATE OR REPLACE FUNCTION accounts.myhstore_merge(myh hstore, mytext
text[])
RETURNS hstore AS
$BODY$BEGIN
SET search_path TO public;
RETURN myh || hstore(mytext);
END;$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
public.hstore(...) would have been much simpler than changing the
search_path, which is persistent to the connection and likely will
backfire if your apps are changing it to something else.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
