Re: Array_agg and dimensions in Array

2019-01-16 Thread Alexey Bashtanov
Hi Mike, I have come across a problem which I cant seem to solve in a nice way Basically I have a (small) table of tags What I need to is combine two concatenated fields with a literal value as an array element. You can create a custom aggregate function like this: alexey@[local]/alexey=# crea

Array_agg and dimensions in Array

2019-01-13 Thread Mike Martin
I have come across a problem which I cant seem to solve in a nice way Basically I have a (small) table of tags What I need to is combine two concatenated fields with a literal value as an array element. First thought was using array_agg with a pre-created array as select array_agg(ARRAY['-metadat