"Yu Jye Foo" <[EMAIL PROTECTED]> writes: > 2008-04-11 09:01:02 PDT ERROR: syntax error at or near "LIMIT" at character > 97 > 2008-04-11 09:01:02 PDT STATEMENT: DELETE FROM BASELINES WHERE file_id IN > (SELECT file_id FROM files WHERE config_id = 1155042061) LIMIT 4001;
Uh, what's your point? DELETE does not have a LIMIT option. Or maybe you meant to put the LIMIT on the SELECT? In that case it should go inside the parentheses. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs