Thread: I hope I'm missing something...

I hope I'm missing something...

From
"brian plummer"
Date:
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/



Re: I hope I'm missing something...

From
Peter Eisentraut
Date:
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.



Re: I hope I'm missing something...

From
Christoph Haller
Date:
> 
> 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