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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs