Re: API Question v7.3

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,
Pennsylvania19073