From: | Philip Hallstrom <philip(at)adhesivemedia(dot)com> |
---|---|
To: | Joshua Adam Ginsberg <rainman(at)owlnet(dot)rice(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PSQL woes |
Date: | 2000-08-10 14:48:53 |
Message-ID: | Pine.BSF.4.21.0008100747280.83606-100000@illiad.adhesivemedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
That doesn't work for me...
I get a parser error...
devloki=> create index foo on rolo_entry (UPPER(text(fname)));
ERROR: parser: parse error at or near "("
-philip
On Thu, 10 Aug 2000, Joshua Adam Ginsberg wrote:
> What I do is just invoke upper(text(field))... that converts the varchar
> to text, which the upper function can then use.
>
> -jag
>
>
> --
> There's so much beauty in the world. Sometimes I feel like
> I'm seeing it all at once, and it's too much; my heart
> fills up like a balloon that's about to burst. And then I
> remember to relax, and stop trying to hold on to it, and
> then it flows through me like rain, and I can't feel
> anything but gratitude for every single moment of my stupid
> little life. -Alan Ball
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mikhail Terekhov | 2000-08-10 14:50:48 | NOTIFY from PL/pgSQL trigger procedure |
Previous Message | Andreas Tille | 2000-08-10 14:45:29 | pg_dump and restore |