Hello! I've got a question: I'm trying to create a system with a string (varchar) primary key which is *not* case sensitive. Is there any way I can create a primary key column which automatically takes care of this? I'm coming at this problem from a java app server, so my hands are somewhat bound regarding the queries used to insert and search the table. There are solutions, but the ideal (for me) would be for the database to ignore the case of my key column. Is this possible? Thanks, Jeff ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
