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