From: | Michael Meskes <meskes(at)postgresql(dot)org> |
---|---|
To: | asergioz(at)bol(dot)com(dot)br |
Cc: | PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: Calculations With NUMERIC Data Type In C Program |
Date: | 2001-06-24 12:39:03 |
Message-ID: | 20010624143903.A30948@feivel.fam-meskes.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Sat, Jun 23, 2001 at 06:16:48PM -0300, asergioz wrote:
> ...
> PostgreSQL. I need to perform several
> calculations, in a C program, with
> data returned from lots of fields of
> the NUMERIC (17, 7)
> data type.
> ...
> EXEC SQL BEGIN DECLARE SECTION;
> numeric(17, 7) var_1;
> numeric(17, 7) var_2;
> long key = 123;
> EXEC SQL END DECLARE SECTION;
I do not know that there is a numeric datatype in C. The datatype's given in
the declare section have to be C types.
> Please, does the ECPG interface work
> with variables of the NUMERIC data
> type, as shown above?
If you can map them to a C datatype yes.
> If not, what are the alternatives?
This is the same problem you run into with any embedded SQL preprocessor
there is.
Michael
--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wagner | 2001-06-25 11:25:19 | Re: passing Windows NT user name to postgres triggers for logging |
Previous Message | Cedar Cox | 2001-06-24 09:35:51 | Re: passing Windows NT user name to postgres triggers for logging |