Skip site navigation (1) Skip section navigation (2)

FUNCTION question

From: "Nico Callewaert" <callewaert(dot)nico(at)telenet(dot)be>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: FUNCTION question
Date: 2009-02-24 12:25:11
Message-ID: 75EF8EA384134D8A86D4D24B02F54811@etsinformatics.local (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: John DeSoiDate: 2009-02-25 00:47:29
Subject: Re: FUNCTION question
Previous:From: Rafael DomicianoDate: 2009-02-23 23:37:02
Subject: Re: PARAMETERS IN QUERIES

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group