Pl/PgSQL String formatting like raise?

From: Csaba Együd <csegyud(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Pl/PgSQL String formatting like raise?
Date: 2009-02-11 06:38:55
Message-ID: gmtrpv$c86$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kusuma Pabba 2009-02-11 06:45:00 creating tables using a file
Previous Message Scott Marlowe 2009-02-11 06:36:01 Re: 'text' is gone?