On Jul 13, 2013, at 24:05, Prabhjot Sheena <prabhjot.sheena@xxxxxxxxxxxxxx> wrote:
> when this value is passed to the function
>
> select load_stage_start_v1('QA_SUMMER'2013_(EU/US)');
>
> This gives an error. Is there a way to fix this issue.
Your issue has nothing to do with stored procedures. You need to escape the string properly for SQL.
select load_stage_start_v1('QA_SUMMER''2013_(EU/US)');
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
