On 1/15/08, Joe Wilson <[EMAIL PROTECTED]> wrote: > > On 1/14/08, mark pirogovsky <[EMAIL PROTECTED]> wrote: > > > Some relational (PostgreSQL for example) databases allow you to store > > > arbitrary array as a field in on row. > > I was not aware of Postgres arrays or that it is part of the > SQL:1999 standard: > > http://www.postgresql.org/docs/8.0/interactive/arrays.html > > Or, for that matter, that postgres supports Set Returning Functions > that can be queried in the FROM clause: > > http://www.postgresql.org/docs/8.0/static/functions-srf.html > > select * from generate_series(2,4); > generate_series > ----------------- > 2 > 3 > 4 > > I suppose that generate_series() could be implemented as an iterator. > > Useful stuff. Thanks for the tip. > >
also very useful (from my pov) as it can avoid several lines of code in the application... SELECT array(i) FROM table or SELECT cols FROM table WHERE array[i] OPERATOR array[j] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------