Thread: 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 inthe 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 pagein 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 pagein 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? > > http://www.postgresql.org/search.mpl > -- 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