Re: array must have even number of elements

2018-09-21 Thread Pavel Stehule
čt 20. 9. 2018 v 20:29 odesílatel Susan Hurst < susan.hu...@brookhurstdata.com> napsal: > Thanks, everyone! > > I get it now. It's not just an array but an hstore array. I changed my > code to include the original values so now it works: > > -- new will be substituted for $1 during execution wit

Re: array must have even number of elements

2018-09-20 Thread Susan Hurst
Thanks, everyone! I get it now. It's not just an array but an hstore array. I changed my code to include the original values so now it works: -- new will be substituted for $1 during execution with using clause l_query_string := 'select ($1 #= hstore(array[' || l_orig_list || '],' || 'a

Re: array must have even number of elements

2018-09-20 Thread Pavel Stehule
Hi čt 20. 9. 2018 v 19:55 odesílatel Susan Hurst < susan.hu...@brookhurstdata.com> napsal: > > Why must an array have an even number of elements? I need to use a > trigger function on any table, some of which may have an odd number of > columns that I want to cleanse before inserting/updating. >