Search Postgresql Archives

Determining if an hstore is empty

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

 



What's the canonical way of doing this? Various failed attempts include:

select array_length(%%'a=>1'::hstore -  'a=>1'::hstore, 1)

select array_length(%%('a=>1'::hstore -  'a=>1'::hstore), 1)

select array_length(avals('a=>1'::hstore -  'a=>1'::hstore), 1);

select array_length(akeys('a=>1'::hstore -  'a=>1'::hstore), 1);

select skeys('a=>1'::hstore -  'a=>1'::hstore) is null

select 'a=>1'::hstore -  'a=>1'::hstore is null

Etc.

--
Wells Oliver
wellsoliver@xxxxxxxxx

[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