postgresql INSERT ... RETURNING query keeps failing?

Posted by KnockKnockWhosThere on Stack Overflow See other posts from Stack Overflow or by KnockKnockWhosThere
Published on 2010-04-20T03:07:56Z Indexed on 2010/04/20 3:13 UTC
Read the original article Hit count: 344

Filed under:
|
|

The error message is kinda vague... The query below works on one server, but fails on another:

INSERT INTO searches (status, uid, datecreated, searchname, options) 
VALUES (0, 1, NOW(), 'TEST', '16') RETURNING sid;

And I get this error:

Query failed: ERROR: syntax error at or near "RETURNING"

Am I missing something here?

© Stack Overflow or respective owner

Related posts about postgres

Related posts about query