PostgreSQL does not allow double quotes :

SELECT * FROM contemplate WHERE type = "foo";

should be written:

SELECT * FROM contemplate WHERE type = 'foo';

In fact, double quotes are treated by PostgreSQL as two single quote.
It should be the same on other SQL92 database systems.

Patch included. Should not produce problems on MySQL.

CommentFileSizeAuthor
contemplate.patch1.18 KBgrub3

Comments

jrglasgow’s picture

jrglasgow commented
Status: Needs review » Fixed

the patch would not apply, I made changes manually, they will appear in the next version of Contemplate.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.