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