pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAPI Question v7.3
2+ messages / 2 participants
[nested] [flat]
* API Question v7.3
@ 2002-10-30 04:45 Evert Carton <evertcarton@netscape.net>
2002-10-30 05:06 ` Re: API Question v7.3 Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: evertcarton@netscape.net @ 2002-10-30 04:45 UTC (permalink / raw)
To: pgsql-interfaces
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: API Question v7.3
2002-10-30 04:45 API Question v7.3 Evert Carton <evertcarton@netscape.net>
@ 2002-10-30 05:06 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2002-10-30 05:06 UTC (permalink / raw)
To: Evert Carton <evertcarton@netscape.net>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-10-30 05:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-30 04:45 API Question v7.3 Evert Carton <evertcarton@netscape.net>
2002-10-30 05:06 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox