Okay, unfortunately there is no coherence between the weekday 0-6 and my table-Field Montag, Dienstag etc. (developed historically) and the execute statement works not too (not with "variable = variable + variable" and not with "select variable + variableb from rdb$database"
Thank you, Dimitry! -----Ursprüngliche Nachricht----- Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> Gesendet: Mittwoch, 28. August 2019 17:31 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Array datatype? 28.08.2019 16:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > is there no way? I know the thing with the execute statement, but it > is not the best solution. I would like to add a value, if the weekday > is 1 (Monday), then I would like to take the variable t1 and add the value from t1 to the sum.. Yes, there is no way. Reconsider your task to more SQL-is way or use dumb solution with CASE, but arrays don't exist in PSQL. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links