Обсуждение: PSQL woes

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

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
>

Will PostgreSQL work on Windows 98?

Thanks,

Bob
rfagan@uswest.net

> Will PostgreSQL work on Windows 98?

No. Read the documentation. The very first page of the administrator's
guide says:

     Note: For Windows NT, the server-side port of Postgres uses the
     RedHat/Cygnus Cygwin library and toolset. For Windows 9x, no
     server-side port is available due to OS limitations.

Ian