Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A76D99FB215 for ; Mon, 27 Nov 2006 10:31:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 95925-01 for ; Mon, 27 Nov 2006 10:30:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx3.ipf.is (man.ipf.is [85.197.192.163]) by postgresql.org (Postfix) with ESMTP id E024A9FA2CA for ; Mon, 27 Nov 2006 10:30:53 -0400 (AST) Received: (qmail 2893 invoked by uid 1010); 27 Nov 2006 14:25:31 +0000 Received: from 88.149.106.19 by man (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.4/1639. spamassassin: 3.1.4. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.5/4.5):. Processed in 2.982559 secs); 27 Nov 2006 14:25:31 -0000 X-Antivirus-HIVE-Mail-From: gnari@hive.is via man X-Antivirus-HIVE: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.5/4.5):. Processed in 2.982559 secs Process 2886) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx3.ipf.is with SMTP; 27 Nov 2006 14:25:28 +0000 Subject: Re: UNICODE and PL/PGSQL From: Ragnar To: Bart Degryse Cc: pgsql-sql@postgresql.org In-Reply-To: <456AD17A020000300000FB60@webaccess.indicator.be> References: <456AD17A020000300000FB60@webaccess.indicator.be> Content-Type: text/plain; charset=ISO-8859-1 Date: Mon, 27 Nov 2006 14:37:31 +0000 Message-Id: <1164638251.27070.45.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/255 X-Sequence-Number: 26907 On mán, 2006-11-27 at 11:52 +0100, Bart Degryse wrote: > Dear all, > This works: SELECT '\x65'; => it returns the letter 'e'. yes, but: test=# select '\x'||'65'; ?column? ---------- x65 (1 row) > When I do the following in PL/PGSQL .... > FOR i IN 101..101 LOOP > charset := charset || '\x' || to_hex(i); > END LOOP; gnari