On Wed, Mar 5, 2008 at 10:39 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Part of the problem is we don't know the length --- it is the compressed > > length that is limited, I think to 8k. > > That's a problem, and the length limit is different for different index > types. So you're really not going to be able to say anything very > specific. Another problem is where would you put the information?
In 'CREATE INDEX' docs... http://www.postgresql.org/docs/8.3/interactive/sql-createindex.html Along with the following statement: method: The name of the index method to be used. Choices are btree, hash, gist, and gin. The default method is btree. Best regards, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad * 18° 32' 57.25"N, 73° 56' 25.42"E - Pune 37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco http://gurjeet.frihost.net Mail sent from my BlackLaptop device
