by tgl@[EMAIL PROTECTED]
(Tom Lane)
Apr 11, 2008 at 01:47 PM
"Yu Jye Foo" <yu.jyefoo@[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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
