Sadly CAST does not work in SQLite, I believe? Not sure if it does anything useful in SQLite, but thankfully at least it is accepted, according to:
http://www.sqlite.org/lang_expr.html

Combing through the PostgreSQL archives , it seems they have been mulling over whether to remove implicit ...

Just upgraded from PostgreSQL 8.2 to 8.3, using Debian defaults. I was burnt by this too.

From the 8.3 release notes :
Non-character data types are no longer automatically cast to TEXT
Arrgh. Anyway, the SQL-compliant way to keep the LIKE operator and also have typecasting happen would be to ...

Yes, as long as you have mod_rewrite enabled, and "AllowOverride All" set in your apache configuration.

The same problem is still in 0.7-rc1.

I've finally gotten my act together to track it down. The glitch is in serendipity_functions.inc.php, and here's the patch. --- serendipity_functions.inc.php.good 2004-10-21 22:51:48.000000000 +0800
+++ serendipity_functions.inc.php 2004-10-21 22:52:30 ...

Oopsie, it looks like the same problem has crawled back into 0.7-beta3.

Just gave 0.7-beta2 a spin. Thank you for making comment moderation work in PostgreSQL. :)

However, when I delete a comment that's pending approval, the "comments" attribute in serendipity_entries table is decremented as if I'm deleting a published comment. If the entry so far does not have any ...