CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...

Поиск
Список
Период
Сортировка
От Philip Hallstrom
Тема CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...
Дата
Msg-id Pine.BSF.4.21.0008092041190.80432-100000@illiad.adhesivemedia.com
обсуждение исходный текст
Ответы Re: CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi -Someone on -general suggested I bring this up here.  I'll try and
explain as much as I can.  If you need more information from me, please
let me know.  I think the easiest way to illustrate this is to just paste
in the output.  This is all happening on FreeBSD 3.4 running 7.0.2.

--------------------------------------------------------------------------
devloki=> CREATE TABLE test (field VARCHAR(10));
CREATE
devloki=> \d test                           Table "test"Attribute |    Type     | Modifier 
-----------+-------------+----------field     | varchar(10) | 

devloki=> INSERT INTO test VALUES ('test string');
INSERT 110505 1
devloki=> SELECT field FROM test;  field    
------------test strin
(1 row)

devloki=> SELECT UPPER(field) FROM test;  upper    
------------TEST STRIN
(1 row)

devloki=> CREATE INDEX test_idx ON test (field);
CREATE
devloki=> CREATE INDEX test_upper_idx ON test (UPPER(field));
ERROR:  DefineIndex: function 'upper(varchar)' does not exist
--------------------------------------------------------------------------

Is there any other information I can provide?  Should I send this on to
-bugs?

Thanks,

-philip



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: Arrays and foreign keys
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...