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

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

2004-09-24 Thread Tom Lane
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 integer helper table but I'm not sure how > to procee

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

2004-09-24 Thread Karsten Hilbert
> You are going to need a set returning function. It will have > to look up the expected boosters, the expected time elapsed, > and return them with their sequence numbers if they exists. > There is no easy way to do it in a view that I can think of. I am not convinced I'll need a SRF. I am not try