BUG #1832: Can't create function in plpgsql which has more than 10 parameters
От | Bohdan Linda |
---|---|
Тема | BUG #1832: Can't create function in plpgsql which has more than 10 parameters |
Дата | |
Msg-id | 20050818124756.79588F0C13@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1832: Can't create function in plpgsql which has more than 10 parameters
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1832 Logged by: Bohdan Linda Email address: bohdan.linda@seznam.cz PostgreSQL version: 7.3.4 Operating system: Solaris Description: Can't create function in plpgsql which has more than 10 parameters Details: I have found if I will create functions as: CREATE OR REPLACE FUNCTION addSyslog ( VARCHAR ,VARCHAR(50) ,INET ,TIMESTAMP ,VARCHAR(255) ,NUMERIC(5) ,NUMERIC ,INET ,INTEGER ,INET ,INTEGER ) RETURNS INTEGER AS ' DECLARE BEGIN RETURN 1; END ' LANGUAGE 'plpgsql'; and I will try to call: SELECT addSyslog('StrA','Strb','100.100.100.100','2005-08-17 12:24:37.545024','aaaaa log message',555,87923463,'192.168.0.1',0,'192.168.0.2',0); I will get: WARNING: plpgsql: ERROR during compile of addsyslog near line 3 ERROR: syntax error at or near "," But if I call: SELECT addSyslog('StrA','Strb','100.100.100.100','2005-08-17 12:24:37.545024','aaaaa log message',555,87923463,'192.168.0.1',0,'192.168.0.2'); everything goes well. I shall be able to pass more than 10 parameters.
В списке pgsql-bugs по дате отправления: