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 -- ------------------------------------------------------------------------------- Syscrusher (Scott Courtney) Drupal page: http://drupal.org/user/9184 syscrusher at 4th dot com Home page: http://4th.com/