Joe Conway wrote:
Andre wrote:
Package variables are not transactional, additionaly they are
session based - each session has it's own variables(values).
You can assign initial(defult) values in package spec.
Using table for them would also imply several columns
for each datatype or several tables
Andre wrote:
Package variables are not transactional, additionaly they are
session based - each session has it's own variables(values).
You can assign initial(defult) values in package spec.
Using table for them would also imply several columns
for each datatype or several tables for them.
I did a
Tom Lane wrote:
[EMAIL PROTECTED] writes:
Oracle has package level variables which are not mappable to any postgres
equivalent.
could we have something like schema scope variables which could be
directly referred from let's say plpgsql functions?
Can someone give me some pointers on how to go abo
[EMAIL PROTECTED] writes:
> Oracle has package level variables which are not mappable to any postgres
> equivalent.
> could we have something like schema scope variables which could be
> directly referred from let's say plpgsql functions?
> Can someone give me some pointers on how to go about imp