Function Issue and casting

From: Juan Pablo Cook <juampick(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Function Issue and casting
Date: 2009-07-04 17:47:34
Message-ID: 90019f490907041047l4f46e144ma52f9fcc6ac960a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi friends, It's my first time I'm writing to the list. All days I enjoy the
list!
I declare a function, and when I want to call this, it fails.

My function:
CREATE OR REPLACE FUNCTION
alta_docente(integer,varchar,varchar,varchar,bigint,varchar,integer)
RETURNS VOID AS
$body$
declare
codigo integer;
begin
INSERT INTO persona(cod,dni,nombre,apellido,domicilio,telefono) VALUES
(DEFAULT,$1,$2,$3,$4,$5);
codigo := currval('persona_cod_seq');

INSERT INTO persona_docente(cod,legajo,antiguedad) VALUES
(codigo,$6,$7);
end;
$body$
LANGUAGE 'plpgsql';

The call I'm doing:
SELECT alta_docente(2323232,cast('Mariela' AS varchar),cast('Botti' AS
varchar),cast('232 de Noviemb23' AS varchar),cast(2312312321AS
bigint),cast('323232A' AS varchar),23)

And here is the error:

ERROR: function alta_docente(integer, character varying, character varying,
character varying, bigint, character varying, integer) does not exist at
character 8
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
STATEMENT: SELECT alta_docente(2323232,cast('Mariela' AS
varchar),cast('Botti' AS varchar),cast('232 de Noviemb23' AS
varchar),cast(2312312321AS bigint),cast('323232A' AS varchar),23)

I don't know what's the problem, because I did all the explicit cast I think
to convert types. If someone can help me, It would be great!

Thanks a lot

JP Cook

Sorry about my bad english!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-07-04 18:25:04 Re: Function Issue and casting
Previous Message Peter Eisentraut 2009-07-04 16:50:22 Re: Installing plpython on 8.4