<schizophrenic> Hi Rob, On Wed, Apr 23, 2008 at 6:47 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Wed, Apr 23, 2008 at 6:39 AM, Morten Primdahl <[EMAIL PROTECTED]> wrote: > > > > Thanks Rob and Baron, I'd never heard of the integers table approach > > before, really good stuff! > > If memory serves postgres has something similar built in, so the > syntax is something like > seq(1..100) or something like that (I can't remember the function name > for the life of me).
What you were thinking of is generate_series ( http://www.postgresql.org/docs/8.3/static/functions-srf.html ) . </schizophrenic> -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]