Date: Tue, 29 Oct 2002 23:45:50 -0500
From: evertcarton@netscape.net (Evert Carton)
To: pgsql-interfaces@postgresql.org
Subject: API Question v7.3
MIME-Version: 1.0
Message-ID: <6E1B9501.5250C157.4B8A5395@netscape.net>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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/