Thread: Pl/PgSQL String formatting like raise?
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
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@gmail.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
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@gmail.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >