Hi everybody,
I have 2 problems and need help. I use FB 2.5.1 and FlameRobin 0.9.3.2210
Unicode.
create domain UINT16 as smallint
default 0
not null
check (value >= 0);
is already defined into database.
First problem :
create table TestTable
(
Number UINT16,
ValuesArr1 UINT16 [0:29]
);
When I tried to create TestTable, I got error :
SQL Error Code: -104
Token unknown -line 4, column 22 [
When I change the array declaration, all goes well.
create table TestTable
(
Number UINT16,
ValuesArr1 smallint [0:29]
);
Is there any restriction on using domain when creating array columns ? I didn't
find anywhere (EmbedSQL, LangRef, etc.) such restriction. Can anybody learn me
what is wrong ?
Second problem :
set term # ;
create procedure spFillData
as
declare i smallint = 0;
declare v smallint = 100;
declare c based on TestTable.ValuesArr1;
begin
while (i < 30) do
begin
c[i] = v + 1;
v = v + 1;
i = i + 1;
end
insert into TestTable values (:i, :c);
end #
set term ; #
This simple procedure would help me to test inserting data in this table. And
then I got to problems.
Impossible to create procedure because " based on " is not recognized.
I search on FB FAQ and forum how to resolve array problem and found nothing.
Can anybody help me to insert and update data into array columns with PSQL ?
Zoe
