[SQLObject] Some Postgres bits

[Frank B. <fb...@fo...>]

Hallo,

I may need case insensitive search in PostgreSQL. "ILIKE" is the case
insensitive "LIKE" in Postgres. Is it somehow possible to inherit and
extend SQLBuilder to present an ILIKE() method (and maybe matching
starts/endswiths)?

Slightly related but also quite off-topic: Importing a CSV-file into a
Postgres-table managed by SQLObject gives "pkey index exists" errors
on the id-column (because the csv contains ids that are already
present and actually should to be updated). The only solution I found
for this is to empty the table with "delete from X" before doing the
"copy from STDIN" import. Does anyone know a nicer way to do this?

ciao
-- 
 Frank Barknecht                               _ ______footils.org__