check for pgsql compatibility - double quotes in SQL queries
scor - January 7, 2009 - 20:01
| Project: | Coder |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs work |
Description
PostgreSQL does not allow double quotes in SQL query values:
SELECT * FROM mytable WHERE type = "val";
should be written:
SELECT * FROM mytable WHERE type = 'val';
here is a first incomplete patch, which catches the patterns "%s".
| Attachment | Size |
|---|---|
| pgsql_coder.patch | 944 bytes |
