ERROR executing Function postgresql

Question

I'm getting mad trying to figure out what I'm doing wrong.
I have a function that starts with:

CREATE OR REPLACE FUNCTION public.insert_contato_site(
_nome character varying,
_sobrenome character varying,
_sexo character varying,
_cpf character varying, 
_nascimento date, 
_end_logradouro character varying, 
_end_numero character varying,
_end_complemento character varying,
_end_bairro character varying,
_end_cidade character varying,
_end_estado character varying,
_end_cep character varying,
_email character varying,
_tel_fixo character varying,
_tel_celular1 character varying,
_metodo_pgto character varying,
_dia_pgto integer, _valor numeric,
_debito_agencia character varying,
_debito_conta character varying,
_cc_num character varying,
_cc_cvv character varying,
_cc_vencimento character varying,
_cc_nome character varying)
     RETURNS integer
     LANGUAGE plpgsql
    AS $function$

When I try to execute it, as the example:

SELECT * FROM insert_contatos_site (
    'John'::VARCHAR,
    'Smith'::VARCHAR,
    'N'::VARCHAR,
    '11111'::VARCHAR,
    '1900-01-01'::DATE,
    'Av Nossa Sra de Copacabana'::VARCHAR,
    '419'::VARCHAR,
    '1'::VARCHAR,
    NULL::VARCHAR,
    'RIO DE JANEIRO'::VARCHAR,
    'RJ'::VARCHAR,
    '22710-790'::VARCHAR,
    NULL::VARCHAR,
    '21 1234-5678'::VARCHAR,
    NULL::VARCHAR,
    'BOLETO'::VARCHAR,
    15,
    200.0,
    NULL ::VARCHAR,
    NULL::VARCHAR,
    NULL::VARCHAR,
    NULL::VARCHAR,
    NULL::VARCHAR,
    NULL::VARCHAR)

It gives me this error:
[42883] ERROR: function insert_contatos_site(character varying, character varying, character varying, character varying, date, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, integer, numeric, character varying, character varying, character varying, character varying, character varying, character varying) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 15

As you can see, all arguments are explcit type cast, but still not working. Ideas?

Khaled · Accepted Answer · 2016-11-04 00:44:36Z

3

You misspelled your function's name it's insert_contato_site without the s

answered Nov 4, 2016 at 0:44

Khaled

4213 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Antonio Over a year ago

haha, can I give my diploma back? Shamed. Thank you very much

Khaled Over a year ago

Lol it's a normal mistake, it was just easier to spot it for me because you were probably too focused on your code :-) My pleasure.

Hambone · Accepted Answer · 2016-11-04 00:52:46Z

1

You misspelled it. It should be:

SELECT * FROM insert_contato_site(

You said:

SELECT * FROM insert_contatos_site(

answered Nov 4, 2016 at 0:52

Hambone

16.5k8 gold badges54 silver badges79 bronze badges

Collectives™ on Stack Overflow

ERROR executing Function postgresql

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related