X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0CF8C3A46B0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Dec 2004 10:46:11 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 99598-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Dec 2004 10:46:01 +0000 (GMT)
Received: from mproxy.gmail.com (mproxy.gmail.com [216.239.56.249])
	by svr1.postgresql.org (Postfix) with ESMTP id 629263A4327
	for <pgsql-sql@postgresql.org>; Sat, 11 Dec 2004 10:46:02 +0000 (GMT)
Received: by mproxy.gmail.com with SMTP id u52so173425cwc
	for <pgsql-sql@postgresql.org>; Sat, 11 Dec 2004 02:46:02 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:return-path:from:to:subject:date:user-agent:organization:mime-version:content-type:content-transfer-encoding:content-disposition:message-id;
	b=NXqB3/jgmaOIMOmwRacme7KoccuyG1EPMf+hFWwzNdWMqdp6hfMhybXutNnbPIdLUevqlEr6ugeAs7UFbLJ9o9BQS20loRHaXIcXmbV2CwuWmFC81qJbbHJkQhSkQDHHUjFGluNlaqPrQncldJG0NbOTTcWWw04y98EyH4mZk8k=
Received: by 10.11.119.44 with SMTP id r44mr596868cwc;
	Sat, 11 Dec 2004 02:46:01 -0800 (PST)
Received: from ?84.243.66.101? ([84.243.66.101])
	by smtp.gmail.com with ESMTP id p77sm32197cwc.2004.12.11.02.46.00;
	Sat, 11 Dec 2004 02:46:01 -0800 (PST)
From: NosyMan <nosyman@gmail.com>
To: pgsql-sql@postgresql.org
Subject: PREPARED STATEMENT
Date: Sat, 11 Dec 2004 12:47:09 +0000
User-Agent: KMail/1.7.2
Organization: Noscom
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200412111247.09108.nosyman@gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.455 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP,
	SUBJ_ALL_CAPS, UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200412/56
X-Sequence-Number: 19676

Hi there,

I want to know that is a posibillity to test if a statement is prepared in=
=20
PL/PgSQL.=20

I have create a function:
=2E........
PREPARE PSTAT_SAVE_record(INTEGER, INTEGER, DATE, VARCHAR) AS INSERT INTO=20
table VALUES($1, $2, $3, $4);
=2E........

When I try to execute it second time I got an error: prepared statement =C2=
=A0
'PSTAT_SAVE_record' already exists. How can I avoid this error? is there a=
=20
posibillity to test if a statement was prepared before?


Thanks,
Nosy