Postgres Pro
Downloads
Home   >   mailing lists

EXECUTE command in stored procedure - Mailing list pgsql-general

From Arunagiri K
Subject EXECUTE command in stored procedure
Date
Msg-id c9bc88a60610070544n546edb45o582a6034731071c1@mail.gmail.com
Whole thread Raw
Responses Re: EXECUTE command in stored procedure  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Martin Steffen
Date:
Subject: failure to connect to postgres DB via pg.el
Next
From: Martin Steffen
Date:
Subject: Re: failure to connect to postgres DB via pg.el