I'm trying to figure out how to implement a more complex constraint within my postgres database than is provided for by simple foreign key constraints and the like. I believe I have to implement a ...

Two questions. I'm having trouble getting postgres to use an index when doing an ORDER BY UPPER(surname), for instance. I can create an index on UPPER(surname), but it doesn't use it in the query - is ...