val_lower in sync and
discard all attempts to write directly to val_lower. Then all
queries would be of the form
SELECT id, val
FROM foo
WHERE val_lower LIKE 'ab%';
Wouldn't want to write every table like this, but if (a) query speed
trumps all othe
epository or (b) get the build to work, so that I don't have
to either give up on pgAdmin or roll back to PostgreSQL 8.2
Thanks,
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
***
PARTIAL RESULTS OF ./configu