PSQL woes

Started by Joshua Adam Ginsbergover 25 years ago6 messagesgeneral
Jump to latest
#1Joshua Adam Ginsberg
rainman@owlnet.rice.edu

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

#2Philip Hallstrom
philip@adhesivemedia.com
In reply to: Joshua Adam Ginsberg (#1)
Re: PSQL woes

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:

Show quoted text

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

#3ROBERT FAGAN
rfagan@uswest.net
In reply to: Philip Hallstrom (#2)
Windows 98

Will PostgreSQL work on Windows 98?

Thanks,

Bob
rfagan@uswest.net

#4Ian Turner
vectro@pipeline.com
In reply to: ROBERT FAGAN (#3)
Re: Windows 98

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

#5Matthew
matt@ctlno.com
In reply to: Ian Turner (#4)
RE: Windows 98

No. It will only work on NT/2000.

Show quoted text

-----Original Message-----
From: ROBERT FAGAN [SMTP:rfagan@uswest.net]
Sent: Thursday, August 10, 2000 12:34 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Windows 98

Will PostgreSQL work on Windows 98?

Thanks,

Bob
rfagan@uswest.net

#6Horák Daniel
horak@sit.plzen-city.cz
In reply to: Matthew (#5)
RE: Windows 98

Will PostgreSQL work on Windows 98?

With the "latest" cygwin (v1.1.x) it will run OK. There are problems with
cygwin B20.

Dan