Subject | How to use arrays? |
---|---|
Author | W O |
Post date | 2013-06-30T20:15:21Z |
Hello
Somebody knows how to use arrays?
I can write it:
CREATE DOMAIN D_ARRAY_1 AS
VARCHAR(10)[12];
but when in a stored procedure I write:
DECLARE VARIABLE MyArray TYPE OF D_ARRAY_1;
appears the message:
"Usage of domain or TYPE OF COLUMN of array type in PSQL."
So, is impossible to use arrays in stored procedures?
Where I can use arrays?
Do you have some example?
Greetings.
Walter.
[Non-text portions of this message have been removed]
Somebody knows how to use arrays?
I can write it:
CREATE DOMAIN D_ARRAY_1 AS
VARCHAR(10)[12];
but when in a stored procedure I write:
DECLARE VARIABLE MyArray TYPE OF D_ARRAY_1;
appears the message:
"Usage of domain or TYPE OF COLUMN of array type in PSQL."
So, is impossible to use arrays in stored procedures?
Where I can use arrays?
Do you have some example?
Greetings.
Walter.
[Non-text portions of this message have been removed]