Date: Fri, 21 Mar 2003 16:53:45 -0300
Message-Id: <HC479L$IV_LImy4TIWPigNNbAWviUDKTgWo@uol.com.br>
Subject: persistent variables between cross-calls in C functions
MIME-Version: 1.0
Content-Type: text/plain;charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
From: "ff" <ff-@uol.com.br>
To: pgsql-interfaces@postgresql.org

Dear all:

I could not find any way to store a value in a C function
between calls.

For example, the following function doesn't work as expected:

	#include "postgres.h"
	#include "fmgr.h"


	PG_FUNCTION_INFO_V1(next_value);

	Datum
	next_value(PG_FUNCTION_ARGS)
	{
		static int n;
		PG_RETURN_INT32(n);
		n++;
	}


select next_value();
will always return 0;

even if I declare n as a global variable outside the fucntion.


Thanks a lot.

Fabio Furia Silva


---
UOL, o melhor da Internet
http://www.uol.com.br/