lovasoa
9 lines
234 B
SQL
9 lines
234 B
SQL
set number_three = sqrt(9.0);
|
|
|
|
select 'text' as component,
|
|
case $number_three
|
|
when '3.0' then 'It works !'
|
|
when '3' then 'It works !'
|
|
else 'error: ' || coalesce($number_three, 'NULL')
|
|
end AS contents;
|