Re: Update HSTORE record and then delete if it is now empty - What is the correct sql?

From: Ashwin Jayaprakash <ashwin(dot)jayaprakash(at)gmail(dot)com>
To: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Update HSTORE record and then delete if it is now empty - What is the correct sql?
Date: 2013-02-23 18:04:56
Message-ID: CAF9YjSA2GE2woG0e5FDN-Pd4Jd9vqrZgQdsFt4yx7Ud8EkJaRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks, that makes sense.

On Fri, Feb 22, 2013 at 9:53 PM, Ian Lawrence Barwick <barwick(at)gmail(dot)com>wrote:

> 2013/2/23 Ashwin Jayaprakash <ashwin(dot)jayaprakash(at)gmail(dot)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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ashwin Jayaprakash 2013-02-23 18:07:28 Re: Update HSTORE record and then delete if it is now empty - What is the correct sql?
Previous Message Don Parris 2013-02-23 18:00:29 Re: Summing & Grouping in a Hierarchical Structure