> I think SQL statement PREPARE *without* parameter is supported, > but one with parameter is not supported (or has some fatal bugs).
It surely should be supported. >> I wrote the source code as follows. >> <test_app.pgc> >> ============================ >> EXEC SQL PREPARE test_prep (int) AS SELECT id from test_table where id = $1; >> EXEC SQL EXECUTE test_prep (2); >> ============================ Please try this instead: EXEC SQL PREPARE test_prep (int) AS SELECT id from test_table where id = $1; EXEC SQL EXECUTE test_prep using 2; This should work. And yes, it does look like a bug to me, or better like changes in the backend that were not synced to ecpg. Michael -- Michael Meskes Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) Meskes at (Debian|Postgresql) dot Org Jabber: michael at xmpp dot meskes dot org VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL
