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 ...
i have two tables that have to have rows inserted. the two tables are modified in a single transaction so that the row is added to both tables or not at all. plus, each of the tables have an "insert ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results