Hasan Mokhtari Sangchi <[EMAIL PROTECTED]> writes: > If I want to create an index on a field by type 'timestamp' > postgres give me following error message : > ' can not find a default operator class for type 1296.' > what can I do ? Upgrade to a more recent version of Postgres. Or, change the field to be type datetime, which is the better-supported datatype in old versions... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl