Postgres problem
От | Ing. Vanek Petr |
---|---|
Тема | Postgres problem |
Дата | |
Msg-id | 38465E14.42E0@mopos.cz обсуждение исходный текст |
Список | 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 по дате отправления: