William Garrison wrote: > I've never worked with a database with arrays, so I'm curious... > > + Efficiency: To return the set_ids for an Item, I could return an array > back to my C# code instead of a bunch of rows with integers. That's > probably faster, right? You should look in to the contrib modules intagg and intarray. In particular contrib/intagg/README.int_aggregate discusses an example quite similar to what you're proposing. Short summary: Seems like a win for very static data, a loss for very dynamic data.
