Re: create function : change name of input parameter
От | Adrian Klaver |
---|---|
Тема | Re: create function : change name of input parameter |
Дата | |
Msg-id | 53F4AC6B.8070507@aklaver.com обсуждение исходный текст |
Ответ на | Re: create function : change name of input parameter (Lori Corbani <Lori.Corbani@jax.org>) |
Ответы |
Re: create function : change name of input parameter
|
Список | pgsql-general |
On 08/20/2014 07:00 AM, Lori Corbani wrote: > > My example: > > DROP FUNCTION ACC_setMax(); > > CREATE OR REPLACE FUNCTION ACC_setMax ( > increment int, > prefixPart varchar(30) = 'MGI:' > ) > RETURNS VOID AS > \$\$ > > > BEGIN > > /* Increment the max MGI Accession Number by @increment */ > update ACC_AccessionMax > set maxNumericPart = maxNumericPart + increment > where prefixPart = prefixPart > ; > > > END; > \$\$ > LANGUAGE plpgsql; > > GRANT EXECUTE ON FUNCTION ACC_setMax(int,varchar) TO public; > > ***** > > When I change the parameter "prefixPart" to "v_prefixPart"....I get the error. > > prefixPart varchar(30) = 'MGI:' > > where prefixPart = prefixPart > > changed to > > v_ prefixPart varchar(30) = 'MGI:' > > where prefixPart = v_prefixPart > Can we see the actual sequence in psql with the command outputs? Also what is escaping the $? -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: