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
>