stroncococcus wrote:
> Ok, solved the problem with COALESCE.
Hm, I not really solved it ... just solved it for text columns, but not
for integer arrays.
I can use this for text
COALESCE(textcol, '') || 'str '
but how do I use this for integers?
Is there a way to create an
Ok, solved the problem with COALESCE.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Hello!
When I try to fill an array with the concatenation operator, like
UPDATE test SET myint = myint || ARRAY[123] WHERE id = 1
that before that statement was null, then it is also null after that
statement.
But if there is already something in that array and I execute that
statement, then every
