Pl/PgSQL String formatting like raise? - Mailing list pgsql-general

From Csaba Együd
Subject Pl/PgSQL String formatting like raise?
Date
Msg-id gmtrpv$c86$1@news.hub.org
Whole thread Raw
Responses Re: Pl/PgSQL String formatting like raise?
List pgsql-general
Hi,
is there a way in a Pl/PgSQL function (PG 8.1.* / 8.3.*) to cut together a
string value like it is done for RAISE Note/Exception?

I'd like to use s.g. like this :

    StrVar := 'select * from t1 where f1=% and f2=%',
quote_literal(Param1),quote_literal(Param2);

Many Thanks!
csaba


pgsql-general by date:

Previous
From: Kusuma Pabba
Date:
Subject: creating tables using a file
Next
From: Craig Ringer
Date:
Subject: Re: 'text' is gone?