[HACKERS] Deferrable Unique Constraints

on a column, you can use a regular index instead of a unique index. Yes, I noticed that getting rid of constraint triggers is also on the TODO list. Below is an example. George Essig -- create table t (x integer, y integer); create index t_x_in on t (x); -- C

Re: [HACKERS] Composite GiST indexes?

ile says it supports the int2, int8, float4, float8, and timestamp data types. George Essig ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match