Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 182A7475D01 for ; Wed, 30 Oct 2002 00:06:08 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 440CE475B8A for ; Wed, 30 Oct 2002 00:06:06 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g9U568v16813; Wed, 30 Oct 2002 00:06:08 -0500 (EST) From: Bruce Momjian Message-Id: <200210300506.g9U568v16813@candle.pha.pa.us> Subject: Re: API Question v7.3 In-Reply-To: <6E1B9501.5250C157.4B8A5395@netscape.net> To: Evert Carton Date: Wed, 30 Oct 2002 00:06:08 -0500 (EST) Cc: pgsql-interfaces@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/82 X-Sequence-Number: 3244 Atttypmod is a generic data type modifier. It is stored in pg_attribute and controls length for varlena types, and precision/decimals for numeric types, among other things. You can look in the adt/* files to see how each type uses atttypmod. --------------------------------------------------------------------------- Evert Carton wrote: > Hi all, > > I am working on an interface between PG73 and SAS shareservers. > SAS-share-servers allow SQL-queries to be passed to the server, and returns results. > > There is a C library for it. > > I chose 7.3, although beta because of the table-API, mainly because of the new API, and the deprecation of the old API. > > I succeeded so far, more or less. I got it working with character data. > The problem lies in numeric and date/time/datatime. > I've been looking for information regarding atttypmod. > Since I don't use libpq, I guess I have to create my own atttypmod value. > But how ? > I found some clues in the sources : src/.../utils/adt/*.c files > Is there some more documentation about the meaning/structure of the atttypmod for the following datatypes : > char > varchar > bytea > numeric > float > date/time/datetime ... > > Regards, > > Evert Carton > Medical Research Laboratories > > __________________________________________________________________ > The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073