[kwlug-disc] Newbie... Playing with Linux etc...

[Adam Glauser]

unsolicited wrote:
> I would 
> have hoped sql is sql, but obviously I'm not speaking from experience, 
> so my opinion is worth zilch.)

Sadly, this is not at all true.  It is certainly possible to restrict 
oneself to ANSI standard SQL, but it takes some forethought.  There are 
some really convenient extensions in each DBMS which are non-standard. 
There is then the matter of the level of ANSI compliance of the various DBs.

If I were trying to write a DB-agnostic application I would most 
certainly use some sort of extraction library rather than trying to keep 
a handle on all of the cross-DB issues myself.