Consider the following sql code:
select cast(cast(10.2 as Decimal(10,2)) as text);
In postgresql it returns 10.2 as text. In decentdb it does not work
select cast(cast(10.2 as Decimal(10,2)) as text);
SQL error: cannot cast Decimal { scaled: 102, scale: 1 } to TEXT
(this is important for the interaction with orms, etc.)
DecentDB version: 2.17.1
Consider the following sql code:
In postgresql it returns 10.2 as text. In decentdb it does not work
select cast(cast(10.2 as Decimal(10,2)) as text);
SQL error: cannot cast Decimal { scaled: 102, scale: 1 } to TEXT
(this is important for the interaction with orms, etc.)
DecentDB version: 2.17.1