Re: Get rid of brackets around variable

Awesome, thanks! Kontakt Geoff Winkless () kirjutas kuupäeval K, 5. veebruar 2020 kell 13:11: > > > On Wed, 5 Feb 2020 at 10:48, Raul Kaubi wrote: > >> >> DO $$ >>> DECLARE >>> cur cursor for >>> select * from (values('logi_web'), ('logi_taustaprotsess')) as q (col1); >>> BEGIN >>> for i in cur

Re: Get rid of brackets around variable

On Wed, 5 Feb 2020 at 10:48, Raul Kaubi wrote: > > DO $$ >> DECLARE >> cur cursor for >> select * from (values('logi_web'), ('logi_taustaprotsess')) as q (col1); >> BEGIN >> for i in cur LOOP >> RAISE NOTICE 'create table %_y2020m01 PARTITION OF % FOR VALUES FROM >> (''2019-12-01'') TO (''2020-01

Get rid of brackets around variable

Hi PostgreSQL 12.1 I am trying to figure out, how can I get rid of brackets for variable. Example as follows: DO $$ > DECLARE > cur cursor for > select * from (values('logi_web'), ('logi_taustaprotsess')) as q (col1); > BEGIN > for i in cur LOOP > RAISE NOTICE 'create table %_y2020m01 PARTITION