Re: [SQL] workaround for missing ROWNUM feature with the help of GUC variables

[Andreas Joseph Krogh]

On 08/04/2010 12:35 PM, Marc Mamin wrote:


Hello,

here my two pence on this recurring thema.

(just a workaround)




I don't understand what you mean by missing ROWNUM feature, PG got this 
with windows-functions in 8.4:

http://www.postgresql.org/docs/8.4/interactive/functions-window.html

Example:
select username, row_number() over() from my_user_table;
  username   | row_number
-+
 admin   |  1
 everyone|  2

--
Andreas Joseph Krogh
Senior Software Developer / CTO
+-+
OfficeNet AS| The most difficult thing in the world is to |
Rosenholmveien 25   | know how to do a thing and to watch |
1414 Trollåsen  | somebody else doing it wrong, without   |
NORWAY  | comment.|
| |
Tlf:+47 24 15 38 90 | |
Fax:+47 24 15 38 91 | |
Mobile: +47 909  56 963 | |
+-+

Re: [SQL] workaround for missing ROWNUM feature with the help of GUC variables

[Marc Mamin]

> I don't understand what you mean by missing ROWNUM feature, PG got
this with windows-functions in 8.4:
> http://www.postgresql.org/docs/8.4/interactive/functions-window.html
 



 

I'm unfortunately still using 8.3.

 

sorry not to have mentioned that.

 

Marc  Mamin