| Lists: | pgsql-interfaces |
|---|
| From: | "brian plummer" <bplummer(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | I hope I'm missing something... |
| Date: | 2004-04-23 23:58:22 |
| Message-ID: | BAY1-F86hg8VMb5UWgP00000d8f@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
I've just spent some time looking at the libpq API and it appears that I
cannot process the actual field data from a select statement in the native
type of that field. Is this correct? For example, if I have an IEEE
floating point number stored in a table and I exec a select to get this
field, my expectation is that when I process my results I will be able to
get a pointer to an IEEE floating point number in my libpq program. It does
not appear that this functionality exists in libpq. Could someone confirm
this. The analogous function in Sybase dblibrary would be dbdata(...). If
I'm wrong, and it is possible to do what I need to do, please point me in
the right direction.
Thanks for your time,
Brian
_________________________________________________________________
Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage!
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "brian plummer" <bplummer(at)hotmail(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: I hope I'm missing something... |
| Date: | 2004-04-25 02:45:17 |
| Message-ID: | 200404250445.17972.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
brian plummer wrote:
> I've just spent some time looking at the libpq API and it appears
> that I cannot process the actual field data from a select statement
> in the native type of that field. Is this correct?
Yes. You are more likely to be happy with ECPG or ODBC, which provide
that functionality.
| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | bplummer(at)hotmail(dot)com |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: I hope I'm missing something... |
| Date: | 2004-04-27 15:04:45 |
| Message-ID: | 200404271304.PAA20524@rodos |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
>
> brian plummer wrote:
> > I've just spent some time looking at the libpq API and it appears
> > that I cannot process the actual field data from a select statement
> > in the native type of that field. Is this correct?
>
> Yes. You are more likely to be happy with ECPG or ODBC, which provide
> that functionality.
>
>
It can give you the native type, but only if you're using binary cursors.
Regards, Christoph