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!
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 |