Re: [SQL] [GENERAL] need ``row number``

2004-09-24 Thread Ian Harding
Right. Sequence within a group. I did this in a SRF resetting the sequence after each subgroup. I would love to see a better way. <<< Greg Stark <[EMAIL PROTECTED]> 9/24 1:42p >>> Tom Lane <[EMAIL PROTECTED]> writes: > Karsten Hilbert <[EMAIL PROTECTED]> writes: > > I am not convinced I'll

Re: [SQL] [GENERAL] need ``row number``

2004-09-24 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Karsten Hilbert <[EMAIL PROTECTED]> writes: > > I am not convinced I'll need a SRF. I am not trying to > > calculate something that isn't there yet. I am just trying to > > join two views appropriately. I might have to employ some > > variant of Celko's integ