Re: Pl/PgSQL String formatting like raise?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Csaba Együd <csegyud(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pl/PgSQL String formatting like raise?
Date: 2009-02-11 07:04:58
Message-ID: 162867790902102304x22c6dc79j240f5970b7ae7e53@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

there is nothing similar. You should to use module plvsubst from Orafce
http://www.postgres.cz/index.php/Oracle_functionality_(en)#PLVsubst

regards
Pavel Stehule

2009/2/11 Csaba Együd <csegyud(at)gmail(dot)com>:
> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2009-02-11 07:05:56 Re: encoding of PostgreSQL messages
Previous Message A. Kretschmer 2009-02-11 06:59:43 Re: creating tables using a file