Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 23F879FA252 for ; Sun, 3 Dec 2006 09:26:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 16353-08 for ; Sun, 3 Dec 2006 09:26:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 873619F9EED for ; Sun, 3 Dec 2006 09:26:36 -0400 (AST) Received: from feivel (c-134-108-14.k.dial.de.ignite.net [62.134.108.14]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 2051ED75FC; Sun, 3 Dec 2006 14:26:33 +0100 (CET) Received: by feivel (Postfix, from userid 1000) id 1B7A1D6EE8; Sun, 3 Dec 2006 14:26:16 +0100 (CET) Date: Sun, 3 Dec 2006 14:26:16 +0100 From: Michael Meskes To: Pawel Hudak Cc: pgsql-interfaces@postgresql.org Subject: Re: ECPGttype/OID Message-ID: <20061203132616.GA32110@feivel.credativ.de> Mail-Followup-To: Pawel Hudak , pgsql-interfaces@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/3 X-Sequence-Number: 6337 On Tue, Nov 28, 2006 at 11:15:49AM +0100, Pawel Hudak wrote: > I'm a little confused regarding type enumerations/defines. > > There is set of OID defines in pg_type.h. These define the OIDs used in the database itself. > But there is also file ecpgtype.h which contains enumeration ECPGttype. These define the numbers used by ecpg to define its datatypes. > Is there any mapping between OID and ECPGttype? No. Well not really. ECPG does have a few conversion routines it needs internally, but a full fledged mapping doesn't really exist. But then you probably don't need one because the client-server conversation is done in ascii most of the time and ecpg takes care of all the conversions needed. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!