Determining if an hstore is empty - Mailing list pgsql-general

From Wells Oliver
Subject Determining if an hstore is empty
Date
Msg-id CAOC+FBXFrSCgq1kN+5oJ=UTpy4yGM=dy7qemNbDedYGRjFB=zQ@mail.gmail.com
Whole thread Raw
Responses Re: Determining if an hstore is empty  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
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@gmail.com

pgsql-general by date:

Previous
From: Andrew Satori
Date:
Subject: Re: fascinating article on postgresql mailing lists
Next
From: Péter Kovács
Date:
Subject: Re: Cache lookup failed for relation