Re: [GENERAL] Join query on 1M row table slow

2004-02-11 Thread Bill Gribble
use some resources on the server side, but it is very much faster than LIMIT/OFFSET. The biggest "gotcha" about cursors is that their lifetime is limited to the enclosing transaction, so they may not be appropriate for CGI-type applications. Bill Gribble ---(

Re: [GENERAL] check date validity

2004-01-18 Thread Bill Gribble
On Fri, 2004-01-16 at 06:58, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > "LitelWang" <[EMAIL PROTECTED]> writes: > > I need this function : > > CheckDate('2002-02-29') return false > > CheckDate('2002-02-28') return true > > Why would you want to do that? Just try to insert '2002-02-2

MySQL is not free software. Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

2003-10-09 Thread Bill Gribble
SQL in any way must be very closely examined, and certainly aren't obvious in the way that the consequences of the GPL are obvious. Thanks, Bill Gribble [1] http://www.mysql.com/products/licensing.html [2] http://www.debian.org/social_contract#guidelines ---