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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Lee Keel
Sent: Monday, October 15, 2007 8:33 AM
To: pgsql-general@postgresql.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.