[neclimdul@gmail.com: Fwd: [development] LinksDB vs. Links]

Syscrusher syscrusher at 4th.com
Thu Aug 3 15:18:51 UTC 2006

On Thursday 03 August 2006 02:18, Sammy Spets wrote:
> For the reference of those that don't know yet, the correct way for both
> MySQL and PostgreSQL is:
>         db_query("word '%s' word");
> Strings in ALL database systems must be encased in single quotes. If you 
> do otherwise you're breaking the SQL standard.

I wondered about that when I saw the original post by Morbus Iff. I use
single quotes all the time in Postgres with Java programming, but I don't
use PG with Drupal or PHP at all, so I just assumed it must be some quirk in
the PHP Postgres libs. Thanks for clarifying. My world is at rest again.


Syscrusher (Scott Courtney)          Drupal page:   http://drupal.org/user/9184
syscrusher at 4th dot com            Home page:     http://4th.com/   

More information about the development mailing list