[SQL] Point and function help

Title: Message Hello all merry XMAS!   I'm trying to create a function that will return a point and having little luck in returning results. Basically I have a zip code DB complete with city, state and zip pre-populated.   What I would like to do is create this function:   CREATE OR REPLACE

Re: [SQL] not in vs not exists - vastly diferent performance

"Iain" <[EMAIL PROTECTED]> writes: > I found this interesting and thought I'd offer it up for comment. You didn't say what PG version you are using, but I'd venture to bet it is pre-7.4. regards, tom lane ---(end of broadcast)--

Re: [SQL] Point and function help

"Andy Lewis" <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION public.map_point(pg_catalog.varchar, > pg_catalog.varchar, pg_catalog.varchar) > RETURNS point AS > 'SELECT map_loc from zip_code where zip = \'$3\' and lower(state) = > lower(\'$2\') and lower(city) = lower(\'$1\')' > LANGUA

Re: [SQL] Point and function help

Thanks Tom, worked like a charm. Appreciate your time on Christmas day! Best Regards and Merry Christmas to all. Andy -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, December 25, 2003 10:44 AM To: Andy Lewis Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Point and

[SQL] Multiple DB servers on a single machine

Dear Friends,   I am having an RH Linux 7.3 box which is already running an Postgres 7.3.4 server. I want to install Postgres 7.4 on the same machine. Is it possible to install different versions of Postgres in a single RH Linux 7.3 box and the postmaster up and running for both (7.3.4 & 7.4