am 14.06.2006, um 15:12:36 +0200 mailte Milen Kulev folgendes: > How to solve my problem ? Is it possible at all to call prepared statement > inside a function at all?
Yes, i have a example: create or replace function foo() returns text as $$ declare sql text; begin sql := 'prepare bla(int) as select now();'; execute sql; sql := 'execute bla(1);'; execute sql; return 'ready'; end $$ language plpgsql; test=*# select foo(); foo ------- ready (1 row) You should execute strings in plpgsql, not prepared statements. HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster