[SQL] Problem with LATIN1 characters from Perl-DBI

2004-09-07 Thread Andreas Joseph Krogh
Hi. I have a database created with -E LATIN1. Inserting norwegian characters lik 'ø' works perfectly from JDBC, but from Perl, it stores the word 'søker' as 'søker'(UNICODE). perl --version: This is perl, v5.8.3 built for i386-linux-thread-multi A Mandrake-10 Linux system. I first had the prob

Re: [SQL] Problem with LATIN1 characters from Perl-DBI

2004-09-07 Thread Andreas Joseph Krogh
On Tuesday 07 September 2004 14:06, you wrote: > Hi. > I have a database created with -E LATIN1. Inserting norwegian characters > lik 'ø' works perfectly from JDBC, but from Perl, it stores the word > 'søker' as 'søker'(UNICODE). > > perl --version: > This is perl, v5.8.3 built for i386-linux-thre

[SQL] Problem with returning setof record

2004-09-07 Thread oliverp21
Hello, Here is a simple function I created for a test. create function ttt() returns setof record as ' declare r record; begin for r in select * from utilisateurs.menus loop return next r; end loop; return; end; ' language 'plpgsql'; When I try to use it, it returns to me : select ttt(); se

Re: [SQL] Problem with returning setof record

2004-09-07 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hello, Here is a simple function I created for a test. create function ttt() returns setof record as ' When I try to use it, it returns to me : select ttt(); set-valued function called in context that cannot accept a set : PL/pgSQL function "ttt" line 5 at return next An