Thanks, that makes sense.
On Fri, Feb 22, 2013 at 9:53 PM, Ian Lawrence Barwick <barw...@gmail.com>wrote: > 2013/2/23 Ashwin Jayaprakash <ashwin.jayaprak...@gmail.com>: > (...) > > > > Q2: What the best way to check if an HSTORE is empty? Is this it > > "array_length(akeys(data), 1) is null"? > > Just a quick answer to your second question: I suspect it might be more > efficient to check your HSTORE column against an empty HSTORE, e.g. > > WHERE val = ''::HSTORE > > HTH > > Ian Barwick >
