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

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...
Date: 2000-08-10 03:54:25
Message-ID: Pine.BSF.4.21.0008092041190.80432-100000@illiad.adhesivemedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2000-08-10 04:49:34 Re: CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...
Previous Message Don Baccus 2000-08-10 01:03:17 Re: Arrays and foreign keys