Error type casts Postgresql function

Question

Hello i have this error

Error: psql:/Samsung/VisualCodeStudioWorkspace/1524335164735.pgsql:95: ERROR: function altaplayer(character varying, integer, integer, character varying, character varying) does not exist LINE 1: select altaPlayer( varchar 'Drazen Petrovic',52,80, varchar ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. psql end.

I cant solve for more than two days... ive tried everyhing...

CREATE TYPE player AS (
    nom varchar(20),
    alçada integer,
    pes integer,
    posicio varchar(20),
    equip varchar(20)
);

CREATE TABLE player_list of player(
    primary key(nom)
);

CREATE TABLE team (
    jugador player
);

INSERT INTO team VALUES(row('Pepelu',190,90,'Base','Barça'));
INSERT INTO player_list VALUES('Asterix',50,30,'Base','Barça');
INSERT INTO player_list VALUES('Pepelui',100,90,'Alero','Barça');
INSERT INTO player_list VALUES('Manolo',10,50,'Base','Barça');
INSERT INTO player_list VALUES('Juan',50,30,'Base','Barça');
INSERT INTO player_list VALUES('Fernando Martin',50,30,'Pivot','Barça');
INSERT INTO player_list VALUES('Audie Norris',50,30,'Pivot','Barça');


create or replace function altaPlayer ( varchar(20),int,int,varchar(20),varchar(20)) as $$
    BEGIN   
        INSERT INTO player_list VALUES($1,$2,$3,$4,$5);
    END
$$ LANGUAGE plpgsql;



select altaPlayer('Drazen Petrovic',52,80,'Escolta','Cibona');

klin · Accepted Answer · 2018-04-21 18:44:54Z

2

The function result type must be specified:

create or replace function altaplayer ( varchar(20),int,int,varchar(20),varchar(20)) 
returns void -- !!!
as $$
    begin   
        insert into player_list values($1,$2,$3,$4,$5);
    end
$$ language plpgsql;

answered Apr 21, 2018 at 18:44

klin

123k15 gold badges240 silver badges262 bronze badges

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

Comments

jose_bacoy · Accepted Answer · 2018-04-21 18:50:10Z

1

You missed to put the keyword RETURNS.

create or replace function altaPlayer
    (varchar(20),int,int,varchar(20),varchar(20)) 
        RETURNS void as $$

answered Apr 21, 2018 at 18:50

jose_bacoy

12.7k1 gold badge25 silver badges41 bronze badges

Collectives™ on Stack Overflow

Error type casts Postgresql function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related