[GENERAL] maintaining backwards compatibility for to_regclass argument type change from cstring to text

2016-11-30 Thread Michael Rasmussen
::cstring); else raise notice '%', to_regclass(myschema||'. '||mytable); end if; I wanted to confirm, is this the best way to approach this? -- Michael Rasmussen Sr. Data Engineer Porch -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your s

[GENERAL] plpgsql multidimensional array assignment results in array of text instead of subarrays

2015-12-28 Thread Michael Rasmussen
le_schema, new_table_name]::text[], but that had no effect. Does anyone know what I might be doing wrong? -- Michael Rasmussen Sr. Data Engineer Porch

Re: [GENERAL] plpgsql multidimensional array assignment results in array of text instead of subarrays

2015-12-28 Thread Michael Rasmussen
||'_source', new_table_name||'_source']]; else the_tables := array[[new_table_schema, new_table_name]]; end if; -- Michael Rasmussen Sr. Data Engineer Porch On 12/28/15, 3:51 PM, "Tom Lane" wrote: >"David G. Johnston" writes: >>