Re: Convert bytea to Float8

> -----Original Message-----
> From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
> Sent: Monday, October 15, 2007 3:54 PM
> To: Lee Keel
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Convert bytea to Float8
>
> 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.

I am sorry to say that the following line did not work. I also tried the
base64 and hex encoding types and got the same error.
select encode(esri_shape::bytea,'escape')::float

I got the following error:
invalid input syntax for type double precision

The data is an ESRI blob and I am trying to convert it to a WKB to store it
in postgis. I was doing this in C# code, but I am getting a string memory
error when I get into some of my large multi-polygons. So, my solution was
to do all the byte parsing on the server. I know the standard way is to
dump to shape file and import from there, but that is too much to ask of my
client to do in this case.

Thanks,
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.