<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
Marco Gaiarin a écrit:<br>
<blockquote type="cite" cite="mid20030116130923.GE1665@sv.lnf.it">
<pre wrap=""></pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!----> <a class="moz-txt-link-freetext" href="http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-REGEXP">http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-REGEXP</a>
No, but pg, as often in GNU programs, have regexp. ;)</pre>
</blockquote>
OK, but can pg use indexes on select with regexp ?<br>
Because the problem is not on "can it be done", but "can it be done FAST",
to avoid a 5-10 seconds waiting time on each biblio select !<br>
<blockquote type="cite" cite="mid20030116130923.GE1665@sv.lnf.it">
<pre wrap="">
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.</pre>
</blockquote>
I agree with you for the schema in a normal form.<br>
Let's release a stable 2.0 and improve this aspect (with many others...)
<blockquote type="cite" cite="mid20030116130923.GE1665@sv.lnf.it">
<pre wrap=""></pre>
</blockquote>
<pre class="moz-signature" cols="$mailwrapcol">--
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre <a class="moz-txt-link-freetext" href="http://www.koha-fr.org">http://www.koha-fr.org</a>)
</pre>
</body>
</html>