lower function

From: Mage <mage(at)mage(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: lower function
Date: 2005-04-06 16:52:18
Message-ID: 425413C2.5020000@mage.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a database with encoding latin2, ctype hu_HU, posgresql 8.0.1.
Keyword split is a plperl function:

create or replace function keywords_split(text) returns text as $$
my $text = lc $_[0];
return $text;
$$
language plperl;

My problem is:

$ psql teszt;
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

teszt=# select lower('úéöÖÉÁ');
lower
--------
úéööéá
(1 row)

teszt=# select keywords_split('AúéöÖÉÁ');
keywords_split
----------------
aúéöÖÉÁ
(1 row)

teszt=# select lower('úéöÖÉÁ');
lower
--------
úéöÖÉÁ
(1 row)

Mage

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-06 16:52:55 Re: Big trouble with memory !!
Previous Message Mohan, Ross 2005-04-06 16:52:16 Install PG 8.0 on AIX 5.2? Any Veterans?