Embedded sql PREPARE statement
Again from the ecpg docs. In http://www.postgresql.org/idocs/index.php?app-ecpg.html it mentions at the end of the page in the NOTES section:
"There is no EXEC SQL PREPARE statement."
I used it in creating a dynamic query and worked just fine. Actually ommiting it causes the program not to work :-(
Is the doc comment obsolete or is there something missing from the functionality of PREPARE?
cheers,
thalis
ps there is even an sqlca error (code -230) related to not having prepared a statement
On Tue, Jun 19, 2001 at 12:57:00PM -0400, Thalis A. Kalfigopoulos wrote:
Again from the ecpg docs. In http://www.postgresql.org/idocs/index.php?app-ecpg.html it mentions at the end of the page in the NOTES section:
"There is no EXEC SQL PREPARE statement."
Ouch, this is way outdated. There is a PREPARE statement.
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
ecpg manual page updated.
On Tue, Jun 19, 2001 at 12:57:00PM -0400, Thalis A. Kalfigopoulos wrote:
Again from the ecpg docs. In http://www.postgresql.org/idocs/index.php?app-ecpg.html it mentions at the end of the page in the NOTES section:
"There is no EXEC SQL PREPARE statement."Ouch, this is way outdated. There is a PREPARE statement.
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026