EXECUTE command in stored procedure

From: "Arunagiri K" <arungi(dot)pgsql(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: EXECUTE command in stored procedure
Date: 2006-10-07 12:44:33
Message-ID: c9bc88a60610070544n546edb45o582a6034731071c1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-10-07 12:53:56 Re: URGENT - startup process (PID 29541) was
Previous Message Andreas Seltenreich 2006-10-07 11:54:41 Re: failure to connect to postgres DB via pg.el