Home > mailing lists

FUNCTION question - Mailing list pgsql-novice

From	Nico Callewaert
Subject	FUNCTION question
Date	February 24, 2009 11:25:20
Msg-id	75EF8EA384134D8A86D4D24B02F54811@etsinformatics.local Whole thread Raw
Responses	Re: FUNCTION question (John DeSoi <desoi@pgedit.com>)
List	pgsql-novice

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: Rafael Domiciano
Date: 23 February 2009, 22:37:06
Subject: Re: PARAMETERS IN QUERIES

From: John DeSoi
Date: 24 February 2009, 23:47:39
Subject: Re: FUNCTION question