SQL Status:42883
От | Andreas Junius |
---|---|
Тема | SQL Status:42883 |
Дата | |
Msg-id | 251545216.20081201182718@junius.info обсуждение исходный текст |
Ответы |
Re: SQL Status:42883
Re: SQL Status:42883 |
Список | pgsql-novice |
Hi Postgres professionals, I hope someone is able to give some advice to the following matter: I created two plpgsql functions, which appear in pgAdminIII as expected. The first one works fine, it has only four arguments. The other one has 10 arguments and I have got the error FEHLER: Funktion md.insertuser(unknown, unknown, unknown, integer, unknown, unknown, unknown, unknown, integer, timestampwith time zone) existiert nicht SQL Status:42883 Hinweis:Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrücklicheTypumwandlungen hinzufügen. Zeichen:15 Ok the message seems to be clear, I have to add some casts (why by the way, the other function didn't need any cast?) If I try it again, I'll get: FEHLER: Funktion md.insertuser(character varying, character varying, timestamp without time zone, integer, character varying,character varying, character varying, timestamp without time zone, integer, timestamp with time zone) existiert nicht SQL Status:42883 Hinweis:Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrücklicheTypumwandlungen hinzufügen. Zeichen:15 I have no idea what to do, because the casts happened, the function has already been there, it should work, but it don't work? The argument list matches exactly. I tried a lot of things, e.g. creating the function without any function, to be sure there is no fault within the function body. I'm grateful for every tip! Andreas
В списке pgsql-novice по дате отправления: