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
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 |