[GENERAL] drawback of array vs join

2009-06-23 Thread Ivan Sergio Borgonovo
I've a temporary table where I'd like to resume data coming from several other tables (normalised the usual way). eg. a list of items that may belong to several group (eg. item, group, itemgroup table) will end up in something similar to: create temp table itemlisttemp( lid int, iid int,

Re: [GENERAL] drawback of array vs join

2009-06-23 Thread Emanuel Calvo Franco
2009/6/23 Ivan Sergio Borgonovo m...@webthatworks.it: I've a temporary table where I'd like to resume data coming from several other tables (normalised the usual way). eg. a list of items that may belong to several group (eg. item, group, itemgroup table) will end up in something similar to:

Re: [GENERAL] drawback of array vs join

2009-06-23 Thread Ivan Sergio Borgonovo
On Tue, 23 Jun 2009 17:39:46 -0300 Emanuel Calvo Franco postgres@gmail.com wrote: 2009/6/23 Ivan Sergio Borgonovo m...@webthatworks.it: I've a temporary table where I'd like to resume data coming from several other tables (normalised the usual way). eg. a list of items that may