type cast of function arguments
От
A B
Тема
type cast of function arguments
Дата
Msg-id
dbbf25900805150744i2751c331y518c99ffae08ed40@mail.gmail.com
Список
Дерево обсуждения
type cast of function arguments "A B" <gentosaker@gmail.com>
Re: type cast of function arguments Tom Lane <tgl@sss.pgh.pa.us>
Re: type cast of function arguments "A B" <gentosaker@gmail.com>
I have written this little silly function
CREATE OR REPLACE FUNCTION recordMail(customerId_ integer, message_
VARCHAR(240)) RETURNS void AS $$
BEGIN
INSERT INTO MailRecord (custid,message) VALUES (customerId_, message_);
END;
$$ LANGUAGE plpgsql;
And it is created, and then I do:
select recordMail(10,'asd');
and I get
ERROR: function recordmail(integer, "unknown") does not exist
LINE 1: select recordMail(10,'asd');
^
HINT: No function matches the given name and argument types. You may
need to add explicit type casts.
What is wrong here and how do I fix it?
В списке pgsql-novice по дате отправления