Search Postgresql Archives
EXECUTE command in stored procedure
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Dear All,
How can I use EXCEUTE command in stored procedures?
When using like this
EXECUTE 'SELECT INTO REGNO REG_NO FROM ADMISSION WHERE SNAME = ' || STUDNAME ;
STUDNAME is a local variable;
I am getting error like this
ERROR: syntax error at or near "INTO" at character 8
How can I solve this.
Regards,
Arunagiri.K
[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]