Search Postgresql Archives

lower function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



       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



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux