Hi,

This is *far for being finished* but I'm working on the function 
ROW_NUMBER( ) OVER( ) and ROWNUM() in order to handle it the same way as 
PostGreSQL. I post it here before going further because I want to know if 
such patch when done have a change to be merged or not.

The idea is to be able to retrieve original row number when using ROWNUM( ) 
in a sub-request. The the following line in document would be removed 
"(even when the  index conditions are specified in an outer query)"

Sample with Postgre:
<raw>
create index on london."osm-line"(highway)
select ROW_ID, highway from (select ROW_NUMBER() OVER () ROW_ID,* from 
london."osm-line") as d where d.highway = 'footway' limit 5;

row_id(int8)                   highway(varchar)               
3                              footway                        
10                             footway                        
11                             footway                        
13                             footway                        
20                             footway      
</raw>

The *first try* of the patch is here, but it return the original index 
without using sub-request, and it is not expected.

https://github.com/nicolas-f/H2-Mirror/commit/7e68a515c2f02e45f890203e1f5e5182a6953606

-Nicolas
IRSTV FR CNRS 2488

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to