Subject Re: [firebird-support] Switch statement in FIREBIRD
Author Milan Babuskov
Mr. John wrote:
> Thanks Milan.
> I'm looking for a C++ swich functionality

But what is the end result: execution of a statement or retrieval of
some value? If you just want to execute procedure which does not return
any database, you shouldn't SELECT at all - select should be used only
when you want to retrieve some data.

In short, I don't think there is a switch statement equivalent in PSQL.
Use IF, ELSE IF and ELSE instead:

if (new.tip = 1) then execute procedure pr1;
else if (new.tip = 6) then execute procedure pr2;
else execute procedure pr3;

Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: