search

digital-guard / preserv-BR

Digital Preservation of Brazilian metadata of donated maps.
http://git.digital-guard.org/preserv-BR
3 stars 1 forks source link

Concatenar json com espaço #165

Closed crebollobr closed 12 months ago

crebollobr commented 12 months ago

Link https://github.com/digital-guard/preserv-BR/tree/main/data/SC/Brusque/_pk0075.02

como fazer properties->'tipo_logr' || ' ' || properties->'logr' AS via, ?

crebollobr commented 12 months ago

funcionou com CONCAT(properties->'tipo_logr', ' ', properties->'logr') AS via