pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Judith Altamirano Figueroa <jaltamirano@correolux.com.mx>
To: pgsql-sql@postgresql.org
Subject: ichar
Date: Tue, 11 Oct 2005 09:22:02 -0500
Message-ID: <1129040522.3426.103.camel@Desarrollo> (raw)

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





view thread (3+ messages)  latest in thread

Message-ID: <1129040522.3426.103.camel@Desarrollo>
Permalink:  ../1129040522.3426.103.camel@Desarrollo/
Also on:    postgresql.org/message-id/1129040522.3426.103.camel@Desarrollo

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jaltamirano@correolux.com.mx
  Subject: Re: ichar
  In-Reply-To: <1129040522.3426.103.camel@Desarrollo>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox