Search Postgresql Archives

Re: Pl/PgSQL String formatting like raise?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Pavel,
thank you very much for your answer.

--
Best Regards,
Csaba Együd

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@xxxxxxxxx>:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux