On 12/08/2013 11:45 AM, Magnus Hagander wrote:
If it's just for a single value, you can just use
SELECT hstore('key', s.part)
It also takes array (either one big array, or one array of keys and
one array of values).
Super! I knew I was missing the obvious.
--
Sent via pgsql-general mail
On Sun, Dec 8, 2013 at 11:22 AM, Kaare Rasmussen wrote:
> Hi
>
> Trying to write a sql function to return hstore generated from a select.
> But I'm thinking there must be a better way.
>
> SELECT 'key => "' || s.part || '"')::hstore
>
> is neither pretty nor secure. At least I need to escape any
Hi
Trying to write a sql function to return hstore generated from a select.
But I'm thinking there must be a better way.
SELECT 'key => "' || s.part || '"')::hstore
is neither pretty nor secure. At least I need to escape any '"' in
s.part. I'll do so if there's no better way to write this (?
