Re: [GENERAL] Convert bytea to Float8

2007-10-16 Thread Lee Keel
> -Original Message- > From: Merlin Moncure [mailto:[EMAIL PROTECTED] > Sent: Monday, October 15, 2007 8:22 PM > To: Lee Keel > Cc: Scott Marlowe; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Convert bytea to Float8 > > > This is sounding more and m

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Merlin Moncure
On 10/15/07, Lee Keel <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Scott Marlowe [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 15, 2007 3:54 PM > > To: Lee Keel > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GEN

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Lee Keel
> -Original Message- > From: Merlin Moncure [mailto:[EMAIL PROTECTED] > Sent: Monday, October 15, 2007 3:26 PM > To: Lee Keel > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Convert bytea to Float8 > > On 10/15/07, Lee Keel <[EMAIL PROTECTED]>

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Lee Keel
> -Original Message- > From: Scott Marlowe [mailto:[EMAIL PROTECTED] > Sent: Monday, October 15, 2007 3:54 PM > To: Lee Keel > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Convert bytea to Float8 > > Does something like: > > select encode(

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Sam Mason
On Mon, Oct 15, 2007 at 03:16:40PM -0500, Lee Keel 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? This question prob

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Scott Marlowe
On 10/15/07, Lee Keel <[EMAIL PROTECTED]> 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

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Merlin Moncure
On 10/15/07, Lee Keel <[EMAIL PROTECTED]> 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? this is trivially done in a

Re: [GENERAL] Convert bytea to Float8

2007-10-15 Thread Lee Keel
:[EMAIL PROTECTED] 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

[GENERAL] Convert bytea to Float8

2007-10-15 Thread Lee Keel
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