"Bannert Matthias" <bann...@kof.ethz.ch> writes: > Fwiw, I was not stubbornly insisting on nesting operators. Actually I > switched from "=>" to the hstore function cause > a note in the manual said it was deprecated > (http://www.postgresql.org/docs/9.0/static/hstore.html). Somehow I must have > understand that note the wrong way. > What's your take on that operator being deprecated?
That's the old SQL operator (which is not even there anymore) that's equivalent to the hstore(text,text) constructor function, ie "text => text returning hstore". It's quite a different concept from the => notation inside an hstore literal. That is: 'foo'::text => 'bar'::text is not like '"foo" => "bar"'::hstore even though they have the same end result. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general