Postgres Pro
Downloads
Home   >   mailing lists

Re: concatenation operator || with "null" array - Mailing list pgsql-general

From stroncococcus
Subject Re: concatenation operator || with "null" array
Date
Msg-id 1165452275.301000.227600@16g2000cwy.googlegroups.com
Whole thread Raw
In response to Re: concatenation operator || with "null" array  ("stroncococcus" <stroncococcus@gmx.de>)
List pgsql-general
Tree view 
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 empty integer array and do such a thing ...
COALESCE(intarraycol, *empty int array*) || 5

pgsql-general by date:

Previous
From: "stroncococcus"
Date:
Subject: concatenation operator || with "null" array
Next
From: "sasan3@gmail.com"
Date:
Subject: can this be done in one SQL selcet statement?!