Postgres problem - Mailing list pgsql-ports

From Ing. Vanek Petr
Subject Postgres problem
Date
Msg-id 38465E14.42E0@mopos.cz
Whole thread Raw
List 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@mopos.cz

pgsql-ports by date:

Previous
From: Patrice TROGNON
Date:
Subject: PostgreSQL on Windows NT 4 ?
Next
From: Jacob Simpson
Date:
Subject: Failed compile on Solaris 2.5.1