3 replies to this topic

[Matthews Estrice]

I would like to create global variables from PL/pgSQL using PostgreSQL 8.1 on the ff. PL/pgSQL.
-- CREATE PACKAGE with global variable
CREATE PACKAGE pack
as
v_seq NUMBER;
END;

PACKAGE funtion in Postges 8.1 PL/pgSQL is deprecated.How can I v_seq a global variable in Postgres 8.1,for v_seq to be available in PROIV?PACKAGE method is now deprecated in 8.1.
Thank you for upcoming ideas.

Matthews Estrice

[Rob_Stebbens]

I would like to create global variables from PL/pgSQL using PostgreSQL 8.1 on the ff. PL/pgSQL.
-- CREATE PACKAGE with global variable
CREATE PACKAGE pack
as
v_seq NUMBER;
END;

PACKAGE funtion in Postges 8.1 PL/pgSQL is deprecated.How can I v_seq a global variable in Postgres 8.1,for v_seq to be available in PROIV?PACKAGE method is now deprecated in 8.1.
Thank you for upcoming ideas.

Matthews Estrice

Are you looking to create a sequence number or a global constant ?
for sequences look at :
create-sequence
drop-sequence
list-sequences

[Matthews Estrice]

I am looking at creating a global constant.

[Richard Bassett]

Just for clarification..
When you say a "global" constant, do you mean a value that multiple processes can see and update or do you mean (as we expect I think) a value that one database connection can see and update (across multiple ProIV functions) and that persists for the lifetime of the connection?