Subject AW: [firebird-support] Array datatype?
Author Check_Mail
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_mail@... [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