č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
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
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.
>