How concat 3 strings if 2 are not empty?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: How concat 3 strings if 2 are not empty?
Date: 2009-02-18 11:50:53
Message-ID: 499BF61D.1000605@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I'd like a function that concats 3 string parameters on condition the
1st and 3rd are NOT empty or NULL.
xCat (s1, s2, s3)
s2 would be a connector that appears only if s1 and s3 are set.

NULL and an empty string '' should be handled the same.

e.g.
'PostgreSQL', ' is ', ' great' --> 'PostgreSQL is great'
NULL, ' is ', ' great' --> 'great'
'PostgreSQL', ' is ', NULL --> 'PostgreSQL'
NULL, ' is ', NULL --> NULL
'PostgreSQL', NULL, ' great' --> 'PostgreSQL great'

Regards
Andreas

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2009-02-18 12:08:05 Re: How concat 3 strings if 2 are not empty?
Previous Message Andreas 2009-02-17 16:30:41 Re: Funtion to clean up strings?