Gurjeet Singh wrote: > 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.
We are trying to figure out how to specify the index-type-specific length limits, not the index types themselves. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-docs
