Re: BUG #8226: Inconsistent unnesting of arrays - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: BUG #8226: Inconsistent unnesting of arrays
Date
Msg-id 20130612110350.GB20851@depesz.com
Whole thread Raw
In response to Re: BUG #8226: Inconsistent unnesting of arrays  (Denis de Bernardy <ddebernardy@yahoo.com>)
List pgsql-bugs
On Wed, Jun 12, 2013 at 12:19:51PM +0200, Denis de Bernardy wrote:
> … where groups is a crazy column containing an array that needed to be
> joined with another table. In this case, you cannot do your suggested
> solution, which would look like this:

Missed this one.

You don't need to unpack to join.

you can do:

select * from tablea join tableb on tableb.id = any (tablea.array_column);

depesz

pgsql-bugs by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: BUG #8226: Inconsistent unnesting of arrays
Next
From: greg@antrez.pl
Date:
Subject: BUG #8227: referential integrity problem