Yes... it is odd... especially since the following works fine:
SELECT UPPER(field) FROM test;
-philip
On Wed, 9 Aug 2000, Lamar Owen wrote:
> Philip Hallstrom wrote:
> > CREATE INDEX test_idx ON test (UPPER(field));
>
> > devloki=> create index foo on rolo_entry (UPPER(fname));
> > ERROR: D
Philip Hallstrom wrote:
> CREATE INDEX test_idx ON test (UPPER(field));
> devloki=> create index foo on rolo_entry (UPPER(fname));
> ERROR: DefineIndex: function 'upper(varchar)' does not exist
> devloki=> create index foo on rolo_entry (UPPER(varchar(fname)));
> ERROR: parser: parse error at
I know... using your example below, try the following:
CREATE INDEX test_idx ON test (UPPER(field));
On my system I get the following errors:
devloki=> create index foo on rolo_entry (UPPER(fname));
ERROR: DefineIndex: function 'upper(varchar)' does not exist
devloki=> create index foo on rolo
Mike Mascari <[EMAIL PROTECTED]> writes:
> Philip Hallstrom wrote:
> >
> > Is there another function that will uppercase? Or is there some way to
> > call the other UPPER function? Or something within plpgsql I don't know
> > about.
> > Thanks!
> > -philip
>
> I don't understand this. UPPER()
Philip Hallstrom wrote:
>
> Is there another function that will uppercase? Or is there some way to
> call the other UPPER function? Or something within plpgsql I don't know
> about.
> Thanks!
> -philip
I don't understand this. UPPER() is a built-in function:
stocks=# create table test (field
Philip Hallstrom wrote:
> Oh... Duh!!! Geesh... for some reason I figured it would call the
> "built-in" UPPER, but obviously it won't. ha ha ha. *sigh*
> My next question then is how to get around this? I could just rename my
> function but it's nice to leave it UPPER since that is what it doe
In article <[EMAIL PROTECTED]>,
Prasanth A. Kumar <[EMAIL PROTECTED]> wrote:
>Philip Hallstrom <[EMAIL PROTECTED]> writes:
>
>> Hi -
>> The following statements lock up my machine completely (I can
>> ping, but can't telnet, nothing). This is FreeBSD 3.4-STABLE running
>> 7.0.2.
>>
>> rolo_
