Re: [SQL] rownum

2003-02-14 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > I've played with this a bit in the past, and concluded that the best way > to do it (if in fact you agree it should be done at all), would be to > add a rownum pseudo column as the results are projected from the backend > to the frontend. I think this wou

Re: [SQL] rownum

2003-02-13 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> sorry about this - braindead and cannot find in doc. what's pg's >> rownum pseudo-column or function name that returns the record number of >> a set? > There isn't one, unless there's something in /contrib that you can build. Right now the only way I've

Re: [SQL] rownum

2003-02-13 Thread Josh Berkus
Chester, > sorry about this - braindead and cannot find in doc. what's pg's > rownum pseudo-column or function name that returns the record number of > a set? There isn't one, unless there's something in /contrib that you can build. -- Josh Berkus Aglio Database Solutions San Francisco --

[SQL] rownum

2003-02-13 Thread chester c young
sorry about this - braindead and cannot find in doc. what's pg's rownum pseudo-column or function name that returns the record number of a set? __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -

[SQL] Rownum/ row Id

2001-01-30 Thread Padmajha Raghunathan
Hi, Is there a provision to delete the duplicate records using row num/ row id as available in Oracle??? Thanx in advance padmajha