Re: [GENERAL] increment row number function question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/07/06 18:47, Matthew Peter wrote: >> Thanks for the reply. Even if such a function existed, it would >> almost certainly not do what you want in this query. Per SQL >> spec, the SELECT target list is logically supposed to be >> evaluated befo

Re: [GENERAL] increment row number function question

Thanks for the reply. <[EMAIL PROTECTED]><[EMAIL PROTECTED]>Even if such a function existed, it would almost certainly not do whatyou want in this query. Per SQL spec, the SELECT target list islogically supposed to be evaluated before the ORDER BY and LIMIT steps, which means you'd get numbers ass

Re: [GENERAL] increment row number function question

Matthew Peter <[EMAIL PROTECTED]> writes: > Hello. I need a way to return an iterator result as a column eg, > SELECT increment() as ii, some_col from some_tbl order by some_col desc limit > 50; Use a sequence for the iterator. -- Jorge Godoy <[EMAIL PROTECTED]> ---

Re: [GENERAL] increment row number function question

Matthew Peter <[EMAIL PROTECTED]> writes: > Hello. I need a way to return an iterator result as a column eg, > SELECT increment() as ii, some_col from some_tbl order by some_col desc limit > 50; > ii | some_col > +-- > 1 | zest > 2 | test > 3 | nest > 4