20 Jul
2018
20 Jul
'18
1:44 p.m.
| From: Alex Volkov via talk <talk@gtalug.org> | On 2018-07-20 03:35 PM, D. Hugh Redelmeier via talk wrote: | > Super naive question: I should disclose just how naive. I've essentially never used SQL. OK, perhaps a query or two when puzzled by MythTV. | > Could you not do this transformation in SQL? | | Yes, now as I've done a bit more research just doing SQL with dblink might be | the way to go. The thing I don't like is SQL for text transformation can be | pretty awkward. Surely there is ssome way to use these functions <https://www.postgresql.org/docs/9.4/static/functions-string.html> Or PL/psSQL or PL/python or PL/java etc.