X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id EA8219DC849
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Feb 2006 21:13:38 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 55893-04
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Feb 2006 21:13:42 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.192])
	by postgresql.org (Postfix) with ESMTP id 8F3C89DC83D
	for <pgsql-interfaces@postgresql.org>;
	Tue, 28 Feb 2006 21:13:35 -0400 (AST)
Received: by uproxy.gmail.com with SMTP id o2so6408uge
	for <pgsql-interfaces@postgresql.org>;
	Tue, 28 Feb 2006 17:13:39 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=Qi+qB9xvbxhJDKWV1s5HOE7BWdl90CLFyLI04xxn4zVl8+JI/9iCCwuBRS677nQ7ZijqCogu0OelThZXAEQz5t3pS01GuamcnLYMGZL0nd8mnfVEuQyb+5AnP6qf5p9r9+JyM+5Oh+2t6f9T/n9w+VG7NMHidqZULP8TLVbO/Q0=
Received: by 10.67.89.2 with SMTP id r2mr668245ugl;
	Tue, 28 Feb 2006 17:13:39 -0800 (PST)
Received: by 10.66.224.11 with HTTP; Tue, 28 Feb 2006 17:13:39 -0800 (PST)
Message-ID: <4a0cafe20602281713p4387cda4p6e25f3b37a8c3ab8@mail.gmail.com>
Date: Tue, 28 Feb 2006 19:13:39 -0600
From: "Josh Close" <narshe@gmail.com>
To: "John DeSoi" <desoi@pgedit.com>
Subject: Re: row description, protocol 3
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3602_13670702.1141175619657"
References: <4a0cafe20602272153s7a3e0c2fme8516170675df1e0@mail.gmail.com>
	<3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.334 required=5 tests=[AWL=0.333,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.334
X-Spam-Level: 
X-Archive-Number: 200602/92
X-Sequence-Number: 6056

------=_Part_3602_13670702.1141175619657
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

>
> The oid maps to the pg_type table:
>
> select oid, typname from pg_type order by oid;
>

So, after a select is done, and I get a row description back, I need to do
another query to find out what the actual type was?

I'm writing a dataprovider, so I need to map the types back to .NET types.
It seems kinda odd that you'd have to do a second query to find out the
type.

------=_Part_3602_13670702.1141175619657
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(=
204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The oid maps=
 to the pg_type table:<br><br>select oid, typname from pg_type order by oid=
;
<br></blockquote></div><br>So, after a select is done, and I get a row desc=
ription back, I need to do another query to find out what the actual type w=
as?<br><br>I'm writing a dataprovider, so I need to map the types back to .=
NET types. It seems kinda odd that you'd have to do a second query to find =
out the type.
<br>

------=_Part_3602_13670702.1141175619657--