Hello,
ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get
row_number
select row_number(), col1, col2...
FROM tableName
Thanks a lot!
Ding Ye
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
On Apr 20, 2011, at 9:15 PM, Emi Lu wrote:
> ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get
> row_number
> select row_number(), col1, col2...
> FROM tableName
Following is a link of deepsz which has a way of implementation of rownum.
http://www.depesz.com/index.php/
If your table is not terribly big, you can
try something like
SELECT a.col1,a.col2, COUNT(*) as row_number
FROM yourTable a,yourTable b
WHERE a.col1 >= b.col1 -- I'm assuming col1 is primary key
GROUP BY a.col1,a.col2
ORDER BY row_number
This is pure SQL, should work in every version...
Bes
I am running into a behavior with a postgresql function with a SETOF
refcursor's returning multiple columns. Not sure if there is a different way to
retrieve a SETOF refcursor's with variable columns? Alternatively can I return
a primitive value and a refcursor from the same function. I tried
Hi guys,
I need your help.
I have a table called medidas, in this table i have some ocurrences that has
id_medida(primary key) id_ponto (sec_key) and also datetime field as
timestamp.
i would like to know from a set of idpontos, e.g. 10,11,23,24 how can i
get the most recent date that is common
