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".

AttachmentSize
pgsql_coder.patch944 bytes
 
 

Drupal is a registered trademark of Dries Buytaert.