Re: Convert bytea to Float8

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Convert bytea to Float8
Дата
Msg-id dcc563d10710151354k32801cf8h627fffcf12556661@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Convert bytea to Float8  (Lee Keel <lee.keel@uai.com>)
Список 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 по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Convert bytea to Float8
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Convert bytea to Float8