Subject AW: [firebird-support] Array datatype?
Author Check_Mail

In my case, I would like to do this:


create procedure P_ARBZEIT(

beginn date,

ende date,

f1 float,

f2 float,

f3 float,

f4 float,

f5 float,

f6 float,

f0 float)

returns (

azeit double precision)


declare variable wt integer;

declare variable akttag date;


azeit = 0;

akttag = beginn;

while (akttag = ende or beginn > ende) do


wt = extract(weekday from :akttag);

azeit = azeit + cast('f'||wt as char(2));

akttag = akttag + 1;







f1 = Monday, f2 = Tuesday.. f0 = Sunday.


I get the day from date with weekday and I would add the value from the day to the azeit. Take the value from the variable f0 when it is Sunday.


My question about the array, because I can set if it is possible (array[0,8,8,8,8,8,0] and array[weekday])


Von: <>
Gesendet: Mittwoch, 28. August 2019 15:29
Betreff: [firebird-support] Array datatype?





I have test something like this:


Declare vat integer[7] or {7}.


How can I define an array datatype and use it in some functions? (vat[1]/vat[countervail])


Thank you.