Postgres problem

From: "Ing(dot) Vanek Petr" <pvanek(at)mopos(dot)cz>
To: pgsql-ports(at)postgresql(dot)org
Subject: Postgres problem
Date: 1999-12-02 11:55:00
Message-ID: 38465E14.42E0@mopos.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Hello,
allow me to approach you about the following matter.

I've got a little problem with Postgres. We use Postgres
version postgresql-6.4.2-3 with RedHat Linux 6.0.
There is one problems in our configuration and one
problem with text strings.

First problem. We want use item with "date" and
Postgres uses date in non europen format. We need
'German' format. It is possible to use "SET DataStyle
To 'German';", but we need declare this format during
start "postmaster", i.e. as daemon. Postgres starting with
"postmaster -i -D /var/lib/pgsql -o e" doesn't work,
it seems. There is environment variable "PGDATESTYLE"
in Postgres, but I do not know there we must declare it.

Second problem we have got with small and capital letters
in "text" items. Than user filles item (via HTML form for
example), item has text string inside. But that string
can be, for example:
Abcdef or ABCDEF or abcdef.
And now we want find that string in database.....
For finding these string we need "non case sensitivity
SELECT". And this is our problem ....

Dear Sirs, could you help me? Be so kind and get me
advice if it is possible.

Yours faithfully Petr Vanek

MOPOS s.r.o.
Smilova 386
530 02 Pardubice
Czech Republic
URL: http://www.mopos.cz
e-mail: pvanek(at)mopos(dot)cz

Browse pgsql-ports by date

  From Date Subject
Next Message Jacob Simpson 1999-12-03 01:02:25 Failed compile on Solaris 2.5.1
Previous Message Patrice TROGNON 1999-12-02 11:08:47 PostgreSQL on Windows NT 4 ?