Developers of Sympa

[Olivier Salaun - CRU <address@concealed>]

I am currently adding new parameters to List::get_first_user used
when Sympa works with a database :
        
        o sortby : may be "domain"(default), "email" or "date"

        o offset, rows : the offset of the row to return and the number 
        of rows. 

When these last parameters are set, a LIMIT clause is added to the SELECT.
Performances are the same while sending a messages. The interrest is
while REVIEWING on the web.

I know MySQL's syntax is :

        SELECT ...FROM...WHERE...[ORDER BY column] [LIMIT [offset,] rows]

What is the format for other DBMS ? ie :

        o PostgreSQL
        o Oracle
        o Sybase

Thanks  

Olivier Salaun
Comite Reseaux des Universites