>
> Why don't you make it simple and just use row_number() from 8.4... It can be
> simplified as:
>
> select row_number() over(), i, p from prueba limit 5;
>
I know the use of WF. What surprised me, is the difference between
both versions in the same query. I'm trying to understand why happens
and
On Thu, Aug 13, 2009 at 9:37 AM, Chris wrote:
> Emanuel Calvo Franco wrote:
>
>>
> But in 8.4 throws this:
>>
>> postgres=# SELECT
>> postgres-# (select count(i)+1 from prueba
>> postgres(# where i < xi.i
>> postgres(# ) as rownum, i, p
>> postgres-# FROM prueba xi limit 5;
>> rownum | i|
Emanuel Calvo Franco wrote:
hi people!
I have this test query to simulate rownums in 8.3:
SELECT
(select count(i)+1 from prueba
where i < xi.i
) as rownum, i, p
FROM prueba xi limit 5;
Devuelve , que esta bien:
1;1;"299361"
2;2;"421127"
3;3;"166284"
4;4;"458945"
5;5;"81619"
But in 8.4 throws
