Home > mailing lists

Function parameter - Mailing list pgsql-general

From	Nico Callewaert
Subject	Function parameter
Date	February 24, 2009 18:15:46
Msg-id	328AA078F4E04573B21FD2AAB62DF221@etsinformatics.local Whole thread Raw
Responses	Re: Function parameter
List	pgsql-general

Hi !

I'm trying to modify an input parameter of a function, but I receive following error :

ERROR: "$17" is declared CONSTANT
CONTEXT: compile of PL/pgSQL function "update_jobreg" near line 26

Is there a way to modify an input parameter or I have to declare a local variable and assign that input parameter to it ?

Many thanks in advance, Nico Callewaert

From: Fujii Masao
Date: 24 February 2009, 15:47:12
Subject: Re: speaking of 8.4...

From: Sam Mason
Date: 24 February 2009, 18:47:01
Subject: Re: Poor select count(*) performance