> -----Original Message----- > From: Merlin Moncure [mailto:mmoncure@xxxxxxxxx] > Sent: Monday, October 15, 2007 3:26 PM > To: Lee Keel > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Convert bytea to Float8 > > On 10/15/07, Lee Keel <lee.keel@xxxxxxx> 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 C procedure on the database....are you > willing to do that? > > merlin At this point I would be willing to try anything. I am just not sure how to do it in C and get it into the database. Can you, or anyone else, help me out with this? I am running postgres 8.2 on a 64 bit windows vista os with VS2005 installed, so: 1) Can I use VS2005 C++ dll? 2) Where do I set the dynamic library path? I found it commented out in the pstgresql.conf file, but it is referencing $libdir. 3) Actually, I have not written C code in so long, I would probably even be better off if I could get someone to write this for me. Sorry for my lack of knowledge on this, but that is outside of my expertise with postgres. Thanks, LK 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
