Received: from aserver.apotres.edu.lb ([194.126.24.131]) by hub.org
	(8.8.8/8.7.5) with ESMTP id DAA01698;
	Wed, 29 Jul 1998 03:11:32 -0400 (EDT)
Received: from cyberia.net.lb ([194.126.24.132]) by aserver.apotres.edu.lb
	(Netscape Messaging Server 3.01)  with ESMTP id 155;
	Wed, 29 Jul 1998 10:06:31 +0100
Message-ID: <35BECC00.1059EB7@cyberia.net.lb>
Date: Wed, 29 Jul 1998 10:15:12 +0300
From: rony khoury <ron@cyberia.net.lb>
Reply-To: ron@cyberia.net.lb
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: "pgsql-novice@postgreSQL.org" <pgsql-novice@postgreSQL.org>,
	"pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: not permanent insert into stud values('myname')
Content-Type: multipart/alternative;
	boundary="------------11A271284A3D47F753F1CB14"


--------------11A271284A3D47F753F1CB14
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Hello ,

following is a part of my code , can any body tell me why it works fine
,
but 'myname' does not remain permanent in the table although I'm loging
in as postgres
and see 'myname' in the result when I run the program ?

thanks ,
Rony .

--------------------- C code -------------------
res = PQexec(conn,"insert into stud values('myname')");
PQclear(res);
res = PQexec(conn,"select * from stud");

for (i=0;i<PQntuples(res);i++) {
  printf("\n answer is %s",PQgetvalue(res,i,0));

---------------------- output -----------------------
#a.out
answer is rony
answer is myname
#
----------------------------------------------------------


--------------11A271284A3D47F753F1CB14
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
<B></B>&nbsp;<B></B>

<P><B>Hello ,</B><B></B>

<P><B>following is a part of my code , can any body tell me why it works
fine ,</B>
<BR><B>but 'myname' does not remain permanent in the table although I'm
loging in as postgres</B>
<BR><B>and see 'myname' in the result when I run the program ?</B><B></B>

<P><B>thanks ,</B>
<BR><B>Rony .</B><B></B>

<P><B>--------------------- C code -------------------</B>
<BR><B>res = PQexec(conn,"insert into stud values('myname')");</B>
<BR><B>PQclear(res);</B>
<BR><B>res = PQexec(conn,"select * from stud");</B>
<BR><B>&nbsp;</B>
<BR><B>for (i=0;i&lt;PQntuples(res);i++) {</B>
<BR><B>&nbsp; printf("\n answer is %s",PQgetvalue(res,i,0));</B><B></B>

<P><B>---------------------- output -----------------------</B>
<BR><B>#a.out</B>
<BR><B>answer is rony</B>
<BR><B>answer is myname</B>
<BR><B>#</B>
<BR><B>----------------------------------------------------------</B>
<BR>&nbsp;</HTML>

--------------11A271284A3D47F753F1CB14--