NDOUtils + PostgreSQL?

[Andreas Ericsson]

Antonio Grassi wrote:
>>>> turn everything up, I see that there are also hardcoded queries with
>>>> MySQL SQL format.
>>> I thought most queries were in ANSI SQL. In what way are the queries
>>> incompatible with PostgreSQL (or any other sql-engine, for that matter)?
>>>
>> I should check the queries again.
> 
> 
> In particular, I've seen the query in src/db.c, line 317:
> 
> "INSERT INTO %s SET instance_name='%s'"
> 
> The INSERT INTO table SET column = value ... is a MySQL extension, as
> described in
> http://dev.mysql.com/doc/refman/6.0/en/extensions-to-ansi.html
> 
> I don't know if there are other non standard queries.
> 

UPDATE %s SET column='%s'

is ANSI though, so that should work pretty much everywhere. So long as
it doesn't overly complicate things, I'm all for following standards.

Were there any complicated cases, or was this all?

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/