Re: Convert bytea to Float8

I am sorry to push this issue, but I have clients waiting on a solution for
this. So, does the lack of response mean that I am going to have to find
another approach? Or can this conversion be done in ppgsql\perl?

Thanks in advance,

Lee Keel

_____

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Lee Keel
Sent: Monday, October 15, 2007 8:33 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Convert bytea to Float8

Can someone please answer what I hope to be an easy question? I am trying
to convert 8 bytes of a bytea into a float8.

In C# this code looks like:

xCoord = System.BitConverter.ToDouble(arrByte, cnt) ;

But in my plpgsql function, the following gives me an error:

xCoord := substring(arrByte from cnt for 8)::float8;

The error that I get is:

ERROR: 42846: cannot cast type bytea to double precision

I have also tried get_byte, but that seems to only be returning the single
byte and not all 8bytes for the float. Thanks in advance.

Lee Keel

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.