Search Postgresql Archives

Re: Opposite function of hstore each function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



ChoonSoo Park wrote:
> Each function returns key/value pairs from hstore type.
> Is there any opposite function that returns hstore type from key/value rows?
> 
> I know hstore (text[], text[]) can construct it. Is there any other choice?
> 
> I have a table with ID & Description columns and want to return hstore type
>  (ID1=>Desc1,ID2=>Desc2,....) that matches a query condition.
>>From top of my head, this is the only query I can think of
> 
> SELECT hstore ((SELECT array(SELECT CAST(ID as TEXT) FROM T1 WHERE ....)),
> (SELECT array(SELECT Description FROM T1 WHERE ...)))
> 
> But I don't want to run the same where condition twice.

You could try:
   select hstore(array_agg(CAST(ID as TEXT)), array_agg(Description)) from T1 where ...

I don't have hstore loaded but that seems like it should work.

HTH

Bosco.

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux