Re: [SQL] Is there a conditional string-concatenation ?

[Joshua Tolley]

On Tue, Oct 12, 2010 at 06:09:07AM +0200, Andreas wrote:
>  Hi,
> Is there a conditional string-concatenation ?

Perhaps this:

CREATE OR REPLACE FUNCTION mycat(text, text, text) RETURNS TEXT LANGUAGE sql
IMMUTABLE AS $$
SELECT CASE
    WHEN $1 IS NULL OR $1 = '' THEN trim($3)
    WHEN $3 IS NULL OR $3 = '' THEN trim($1)
    ELSE trim($1) || trim(coalesce($2, '')) || trim($3)
END;

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

signature.asc
Description: Digital signature