Re: powerset?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Ben <bench(at)silentmedia(dot)com>
Cc: "PostgreSQL General ((EN))" <pgsql-general(at)postgresql(dot)org>
Subject: Re: powerset?
Date: 2006-09-24 15:02:23
Message-ID: 20060924150223.GA28717@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Sep 23, 2006 at 11:47:59PM -0600, Michael Fuhr wrote:
> FOR i IN 0 .. (1 << (aupper - alower + 1)) - 1 LOOP

To handle empty arrays this should be:

FOR i IN 0 .. COALESCE((1 << (aupper - alower + 1)) - 1, 0) LOOP

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-09-24 15:18:26 Re: Restart after poweroutage
Previous Message Jon Lapham 2006-09-24 13:11:00 Restart after poweroutage