On Tue, Dec 04, 2007 at 03:15:12PM -0800, Frank Conradie wrote:
> * postgresql: does not even have any sort of REPLACE at all (AFAICT)
It doesn't.
> * sqlite: REPLACE works like its INSERT: /"The REPLACE command is an
> alias for the "INSERT OR REPLACE" variant of the INSERT command. This
> alias is provided for compatibility with MySQL.". /
Yes, this time you are right - REPLACE in SQLite is a variant of INSERT.
Nobody has complained yet about absent of proper support of REPLACE with
SQLite, so I think people use REPLACE only with MySQL.
> So if I wanted to improve the sqlbuilder Replace, I guess it would be
> best to have a totally new Replace expression (not inheriting from
> Insert or Update), and then have lots of these:
> if db == "..."
Yes, but I don't think there will be a lot of "if"s - MySQL and SQLite.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
