Re: Convert bytea to Float8 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Convert bytea to Float8
Date
Msg-id dcc563d10710151354k32801cf8h627fffcf12556661@mail.gmail.com
Whole thread Raw
In response to Re: Convert bytea to Float8  (Lee Keel <lee.keel@uai.com>)
List pgsql-general
On 10/15/07, Lee Keel <lee.keel@uai.com> wrote:
>
>
>
>
> 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?

Does something like:

select encode('12346758'::bytea,'escape')::float

work?

Since I'm not sure what format your data is stored in I'm just guessing here.

Note that you could use get_byte and cycle through the offset to get
each byte as well.

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Convert bytea to Float8
Next
From: Sam Mason
Date:
Subject: Re: Convert bytea to Float8