On Wed, Feb 18, 2004 at 01:40:00AM -0000, Greg Sabino Mullane wrote:
> Fabrizio Mazzoni asked:
>
> > How can i find out if a prepared statement already exists..? Is there a
> > function or a query i can execute ..??
>
> I have not seen an answer to this, and I am curious as well. Anyone?
Trying to prepare a dummy query maybe.
alvherre=# prepare foo as select 1;
PREPARE
alvherre=# prepare foo as select 2;
ERROR: la sentencia preparada "foo" ya existe
alvherre=# execute foo;
?column?
----------
1
(1 fila)
> (Cross-posting to hackers due to the lack of response on general)
Wow, you are really desperate. Cc'ed two times!
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Es filósofo el que disfruta con los enigmas" (G. Coli)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
