Concatenating String Literals in pgsql - Mailing list pgsql-general

From Raymond
Subject Concatenating String Literals in pgsql
Date
Msg-id 200308101506.00331.support@bigriverinfotech.com
Whole thread Raw
Responses Re: Concatenating String Literals in pgsql
List pgsql-general
How does one concat string literals in pgsql ?

The compiler complains about the concat operator in the following code
fragment:

RAISE EXCEPTION
    ''SELECT DISTINCT "t1"."usesysid" '' ||
        ''INTO userID '' ||
        ''FROM "pg_user" AS "t1" '' ||
        ''WHERE "t1"."usename" = current_user '' ||
        ''NOT FOUND'';

Thanks in advance.

Raymond

pgsql-general by date:

Previous
From: Robert Creager
Date:
Subject: Re: How to prevent vacuum and reindex from deadlocking.
Next
From: "Gregory S. Williamson"
Date:
Subject: High volume use of postGres