Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA23146; Thu, 30 Jul 92 10:27:18 -0700
Date: Thu, 30 Jul 92 10:27:18 -0700
Message-Id: <9207301727.AA23146@postgres.Berkeley.EDU>
From: newman-andy@yale.edu
Subject: text_ops problem
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

Greetings,

Regarding Postgres 4.0 bugs, it appears that creating a secondary
index on a field of type 'text' doesn't work.

	define index idx on dict using btree (word text_ops)

completes without error but an attempt to retrieve values on the
class 'dict' using a limiting clause operator '=' fails to ever
return values.

	retrieve (dict.all) where dict.word = "test"

fails.  Before generating the index, this query would return one or more
records.  After, it reliably returns nothing.  The whole scenario
works as expected if the type is char16 or any other type.  Anyone else
seen this?  (BTW, the behavior is consistent on both Dec Ultrix boxes
and Suns running SunOS)


*  ===\  |===|  ===\  *========================================================
*  |       |    |  |  *                 -Andrew Newman                        *
*  |==|    |    |==/  *                  C&IS Systems Technology & Planning   *
*     |    |    |     *                  Yale University                      *
*  \===    |    |     *                  (newman-andy@yale.edu)               *
*---------------------*========================================================