From ryccosta@satlink.com Thu Apr  6 01:09:22 2000
Received: from infoviaplus.net.ar (adv17.infoviaplus.net.ar [200.9.212.61])
	by hub.org (8.9.3/8.9.3) with ESMTP id VAA81342
	for <pgsql-sql@postgresql.org>; Wed, 5 Apr 2000 21:09:22 -0400 (EDT)
	(envelope-from ryccosta@satlink.com)
Received: from infovia ([209.13.202.2]) by infoviaplus.net.ar
	(Tid InfoMail Exchanger v2.20) with SMTP id #954983183.007980001;
	Wed,  5 Apr 2000 22:06:23 -0300
Message-ID: <000801bf9f64$09d0fb60$02ca0dd1@infovia.com.ar>
From: "Teresa Mozejko -  Ricardo Costa" <ryccosta@satlink.com>
To: <pgsql-sql@postgresql.org>
Subject: libpq
Date: Wed, 5 Apr 2000 22:04:16 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01BF9F4A.E2E94D40"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Infomail-Id: 954983183.031E01AC1E039E.23183
X-Archive-Number: 200004/49

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BF9F4A.E2E94D40
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is there an example using libpq or libpq++ which includes table creation an=
d filling as well as queries. I would really appreciate this information, b=
ecause the examples included in the postgres manual are not complete enough.


------=_NextPart_000_0005_01BF9F4A.E2E94D40
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Is there an example using libpq or libpq++ which includ=
es=20
table creation and filling as well as queries. I would really appreciate th=
is=20
information, because the examples included in the postgres manual are not=
=20
complete enough.</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0005_01BF9F4A.E2E94D40--




From alagnada@lsil.com Thu Apr  6 15:16:28 2000
Received: from lsi.lsil.com (lsi.lsil.com [147.145.40.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA86259
	for <pgsql-sql@postgresql.org>; Thu, 6 Apr 2000 11:16:28 -0400 (EDT)
	(envelope-from alagnada@lsil.com)
Received: from mhbs.lsil.com ([147.145.31.100])
	by lsi.lsil.com (8.9.3+Sun/8.9.1) with ESMTP id IAA12957
	for <pgsql-sql@postgresql.org>; Thu, 6 Apr 2000 08:15:57 -0700 (PDT)
Received: from mms10.lsil.com by mhbs.lsil.com for pgsql-sql@postgresql.org;
	Thu, 6 Apr 2000 08:15:43 -0700
Received: from lsil.com by mms10 (SMI-8.6/SMI-SVR4)
	id KAA23514; Thu, 6 Apr 2000 10:15:40 -0500
Message-Id: <38ECAA1B.E85CFE91@lsil.com>
Date: Thu, 06 Apr 2000 10:15:39 -0500
From: "Antonio W. Lagnada" <alagnada@lsil.com>
Organization: LSI Logic Corporation
X-Mailer: Mozilla 4.61 [en] (X11; U; SunOS 5.6 sun4m)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: libpq
References: <000801bf9f64$09d0fb60$02ca0dd1@infovia.com.ar>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200004/52

I too would like to see an example.  Reading the header files just
didn't cut it for me
> Teresa Mozejko - Ricardo Costa wrote:
> 
> Is there an example using libpq or libpq++ which includes table
> creation and filling as well as queries. I would really appreciate
> this information, because the examples included in the postgres manual
> are not complete enough.
> 

--

Antonio W. Lagnada
Silicon Optimization
http://wwwmm.lsil.com/~alagnada (internal)
(612) 921 8533



From dmitigr@gmail.com Tue Aug  10 13:35:21 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id D049E632BBB
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 10 Aug 2010 10:35:21 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 61754-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 10 Aug 2010 13:35:13 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id 987DE632712
	for <pgsql-sql@postgresql.org>; Tue, 10 Aug 2010 10:35:14 -0300 (ADT)
Received: by fxm13 with SMTP id 13so646921fxm.19
	for <pgsql-sql@postgresql.org>; Tue, 10 Aug 2010 06:35:13 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:date:message-id
	:subject:from:to:content-type;
	bh=fqa8begVIWAkOYyplG66iOe0gGbDApc6/OLLKMDXkiQ=;
	b=vYkpFBnCW3VUb4VBaAWdd/JBDb65ulp2sSP3SCrfmhn/b7l25O/G9sxtYiI3Abbnky
	jT+0051N6YowlBmuMfWe42fvO3E7KWS9XF5sLnnSoT5pDN+KYsKlqHGdUDQhvZsuEHfd
	TdmORUoHjq+Bt7QELsn+bUOR/GA8Iffnlb40g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=sXTFvdVZjs2D5vXtJCiwFTJDea9j0agN4r2GxKPO2/ZzdKlg3QrFfQaKX52I5wh1Wq
	ZR6mWwL7f3UVOgBs5WZrss8vLHFPiFxgC4Pn93ULKvq2YO8vh/uGHEyFJxmRsYaBUcVS
	wr7lZhBXL6P95r/FkaYK5ATOsVLki5iG8kilQ=
MIME-Version: 1.0
Received: by 10.103.24.15 with SMTP id b15mr1301364muj.39.1281447312793; Tue,
	10 Aug 2010 06:35:12 -0700 (PDT)
Received: by 10.103.89.17 with HTTP; Tue, 10 Aug 2010 06:35:12 -0700 (PDT)
Date: Tue, 10 Aug 2010 17:35:12 +0400
Message-ID: <AANLkTikAAdoXd2WCsBa6=YG5qwu4of8ZO-XpH9Q+FRNs@mail.gmail.com>
Subject: libpq
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: postgres list <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary=0016e65a0fbce0a0eb048d7833bc
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=-5 required=5 tests=BAYES_40=-0.001,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/42
X-Sequence-Number: 34482

--0016e65a0fbce0a0eb048d7833bc
Content-Type: text/plain; charset=ISO-8859-1

Hey all,

Is it guaranteed that functions, which accept PGconn* properly
works if PGconn* is NULL (or just 0) and returns in such cases
the same values as for not-NULL PGconn* ?
If so, I think it should be documented ?!

Regards,
Dmitriy

--0016e65a0fbce0a0eb048d7833bc
Content-Type: text/html; charset=ISO-8859-1

Hey all,<br><br>Is it guaranteed that functions, which accept PGconn* properly<br>works if PGconn* is NULL (or just 0) and returns in such cases<br>the same values as for not-NULL PGconn* ?<br>If so, I think it should be documented ?!<br>
<br>Regards,<br>Dmitriy<br><br>

--0016e65a0fbce0a0eb048d7833bc--



From dmitigr@gmail.com Thu Aug  12 14:47:52 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 33B39632665
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 12 Aug 2010 11:47:52 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 54245-09
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 12 Aug 2010 14:47:43 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id E709F633C80
	for <pgsql-hackers@postgresql.org>;
	Thu, 12 Aug 2010 11:47:44 -0300 (ADT)
Received: by fxm13 with SMTP id 13so757623fxm.19
	for <pgsql-hackers@postgresql.org>;
	Thu, 12 Aug 2010 07:47:42 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:content-type;
	bh=14YG7xx+vL1+91eLpE/Zsp8dpCXy9/PIHzKQ6gH1FFo=;
	b=sJiA0Oxo6jSeSxYPq6oKiUTVBIHIW/hjkNZJvQJiBRxvYbtww53hH1hXYVNFciPYIb
	6f3CwlDd39UgFheSnXOEW4z8MHdj0Efk9YM9t+F3wIcoSWlpi4JTNQ0AdJWpeSrc7n/X
	oj+O0gz5jzfr3C1TQEA/qbSkSS7eihJhLo2M0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=JSyFH7MnhjZfwui2PgIwa8rEU5CEhQN78PLVG9wV/DDY17WPumGG6yZ9fAREfhXfKL
	VMm/bBqK5knElZr+AZ4FYDt+wWhmNC155XCXCQQ+c1Jo0KxbrUVZuCMRTTF3DxfN/zSM
	JDUooJwH8206kyxLHbJf6uZkm1bT7hdTo+UZU=
MIME-Version: 1.0
Received: by 10.103.217.14 with SMTP id u14mr36021muq.2.1281624462783; Thu, 12
	Aug 2010 07:47:42 -0700 (PDT)
Received: by 10.103.89.17 with HTTP; Thu, 12 Aug 2010 07:47:42 -0700 (PDT)
In-Reply-To: <AANLkTikAAdoXd2WCsBa6=YG5qwu4of8ZO-XpH9Q+FRNs@mail.gmail.com>
References: <AANLkTikAAdoXd2WCsBa6=YG5qwu4of8ZO-XpH9Q+FRNs@mail.gmail.com>
Date: Thu, 12 Aug 2010 18:47:42 +0400
Message-ID: <AANLkTinYe8NMiegT27grzm+H1Zu+9Ufs==_LEVFNLBSg@mail.gmail.com>
Subject: libpq
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: pgsql-hackers@postgresql.org
Content-Type: multipart/alternative; boundary=0016e6d622ced6f40f048da172e8
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/909
X-Sequence-Number: 167712

--0016e6d622ced6f40f048da172e8
Content-Type: text/plain; charset=ISO-8859-1

Hey all,

Is it guaranteed that functions, which accept PGconn* (PGresult*)
properly works if PGconn* (PGresult*) is NULL or is it better to check
on NULL the value of the pointer before calling those functions?

Regards,
Dmitriy

--0016e6d622ced6f40f048da172e8
Content-Type: text/html; charset=ISO-8859-1

Hey all,<br><div class="gmail_quote"><br>Is it guaranteed that functions, which accept PGconn* (PGresult*)<br>properly works if PGconn* (PGresult*) is NULL or is it better to check<br>on NULL the value of the pointer before calling those functions?<br>
<br>Regards,<br><font color="#888888">Dmitriy<br><br></font></div>

--0016e6d622ced6f40f048da172e8--



From tgl@sss.pgh.pa.us Thu Aug  12 15:05:01 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id EED5F632D76
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 12 Aug 2010 12:05:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 66525-03
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 12 Aug 2010 15:04:54 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id A49C6632665
	for <pgsql-hackers@postgresql.org>;
	Thu, 12 Aug 2010 12:04:53 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o7CF4qia014369;
	Thu, 12 Aug 2010 11:04:52 -0400 (EDT)
To: Dmitriy Igrishin <dmitigr@gmail.com>
cc: pgsql-hackers@postgresql.org
Subject: Re: libpq 
In-reply-to: <AANLkTinYe8NMiegT27grzm+H1Zu+9Ufs==_LEVFNLBSg@mail.gmail.com> 
References: <AANLkTikAAdoXd2WCsBa6=YG5qwu4of8ZO-XpH9Q+FRNs@mail.gmail.com>
	<AANLkTinYe8NMiegT27grzm+H1Zu+9Ufs==_LEVFNLBSg@mail.gmail.com>
Comments: In-reply-to Dmitriy Igrishin <dmitigr@gmail.com>
	message dated "Thu, 12 Aug 2010 18:47:42 +0400"
Date: Thu, 12 Aug 2010 11:04:52 -0400
Message-ID: <14368.1281625492@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201008/910
X-Sequence-Number: 167713

Dmitriy Igrishin <dmitigr@gmail.com> writes:
> Is it guaranteed that functions, which accept PGconn* (PGresult*)
> properly works if PGconn* (PGresult*) is NULL or is it better to check
> on NULL the value of the pointer before calling those functions?

I think they all do check for NULL, but whether they give back a default
result that's useful for you is harder to say.

			regards, tom lane