Re: Get rid of brackets around variable

2020-02-05 Thread Raul Kaubi
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

2020-02-05 Thread Geoff Winkless
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