Re: [HACKERS] Index on wide column

2001-10-24 Thread Tom Lane
Antonio Sergio de Mello e Souza <[EMAIL PROTECTED]> writes: > I need to perform a tree traversal on a big table (millions of rows). > To avoid recursive queries, one for each non-leaf node, this table has, > in addition to its 70 columns, a VARCHAR(3) column that is used > exclusively to sort

[HACKERS] Index on wide column

2001-10-24 Thread Antonio Sergio de Mello e Souza
Hi all, I need to perform a tree traversal on a big table (millions of rows). To avoid recursive queries, one for each non-leaf node, this table has, in addition to its 70 columns, a VARCHAR(3) column that is used exclusively to sort the rows with the required order. The actual content leng