27 Aug
2006
27 Aug
'06
11:34 a.m.
Looking at the UPDATE and the SELECT queries above... They are completely invalid. It's not even propper SQL syntax... UNLESS, expiry time *should* be a varchar instead of a datetime field - which again makes the database very big. Let's face it, a varchar uses a lot more space than a datetime, or even a int - should UNIX_TIMESTAMP be used instead.
It is very unlikely that it will work with MySQL. It is designed for Postgresql.
Classic homer simpson style... *DOH* Guess I'll have to sit back and wait for mysql support then... This will also explain my other post then about not being able to reconnect to the databases I suppose... -- C