X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id DF6D3D7012
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 11 Oct 2005 11:22:04 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 07903-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 11 Oct 2005 14:21:59 +0000 (GMT)
Received: from CORREO.correolux.com.mx
	(customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218])
	by svr1.postgresql.org (Postfix) with ESMTP id AADB3D6E94
	for <pgsql-sql@postgresql.org>; Tue, 11 Oct 2005 11:22:00 -0300 (ADT)
Received: from 192.168.7.58 ([192.168.7.58]) by correolux.com.mx with
	MailEnable ESMTP; Tue, 11 Oct 2005 09:20:00 -0600
Subject: ichar
From: Judith Altamirano Figueroa <jaltamirano@correolux.com.mx>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Date: Tue, 11 Oct 2005 09:22:02 -0500
Message-Id: <1129040522.3426.103.camel@Desarrollo>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 (2.0.2-3) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.052 required=5 tests=[AWL=0.002,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/88
X-Sequence-Number: 22941

I moved from postgres 7.0.2 to 8.0.1,

in the 7.0.2 version I process the next query, and it succeed:

select ichar(letra_ascii) || '-' || substr('00000' ||num_factura,length
(num_factura)+1,5) as factura from facturas 

but in 8.0.1 it outputs the next error:

ERROR:  not exist the function ichar(integer) 
HINT:  any function match with the arguments types.
Add explicit cast of types