blob: d2acbd2b8817bdb8a675628373e692d386979e87 (
plain) (
blame)
1
2
3
4
5
6
|
PRAGMA DisableSimpleColumns;
/* postgres can not */
select Input1.key, Input1.subkey, SimpleUdf::Concat(coalesce(Input1.value, ""), coalesce(Input3.value, "")) as value
from plato.Input1
full join plato.Input3 using (key)
order by Input1.key, Input1.subkey, value;
|
