[Koha] MySQL and foreign keys
Marco Gaiarin
gaio at sv.lnf.it
Fri Jan 17 02:09:23 NZDT 2003
Mandi! paul POULAIN
In chel di` si favelave...
> i've bad news for you Marco...
Sure?!
> we have decided recently to go ... to a deepest mySQL dependency.
> mySQL has a feature that doesn't exist in ANSI-SQL92 : full-text indexing.
http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-REGEXP
No, but pg, as often in GNU programs, have regexp. ;)
I think it is not the case to fight against one or other DBMS, simply
wrote down a correct relational database schema in normal form, and put
inside as standard as possible SQL instructions, for the rest using
specialized instructions case()ing on the DBMS type.
As suggested.
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN)
gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
Difendiamo PeaceLink!
Campagna di solidarietà per la tutela legale di una voce scomoda.
http://www.peacelink.it/emergenza/
More information about the Koha
mailing list