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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
