Developers of Sympa

[address@concealed]

This is a bug report..

I just installed 2.7b3.  FreeBSD 4.0 stable; Postgres 7.0.  

Apparently the syntax on the LIMIT statement is backwards.  Postgres
wants it like this:
      LIMIT { count | ALL } [ { OFFSET | , } start ]

The second one is correct...

www# fgrep LIMIT List.pm.orig 
            ## LIMIT clause
                $statement .= sprintf " LIMIT %d, %d", $offset, $rows;
www# fgrep LIMIT List.pm     
            ## LIMIT clause
                $statement .= sprintf " LIMIT %d, %d", $rows, $offset;




By the way, sympa rocks!  I love all it's capability!