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