[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