Postgres Pro
Downloads
Home   >   mailing lists

Re: Create function errors - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Create function errors
Date
Msg-id a55915760712041726x781ce41fm1d40d5518f4914ae@mail.gmail.com
Whole thread Raw
In response to Create function errors  ("Peck, Brian" <brian.peck@lmco.com>)
List pgsql-general
Tree view 
On Dec 4, 2007 6:04 PM, Peck, Brian <brian.peck@lmco.com> wrote:

>             SELECT source_id as vertex INTO result FROM $3 ORDER BY
> Distance(the_geom,PointFromText(POINT( $1 $2 ))) LIMIT 1;

I think you're missing a comma, e.g. POINT( $1 , $2 ).

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Avoid huge perfomance loss on string concatenation
Next
From: Ow Mun Heng
Date:
Subject: Windows Client App Was [Re: Tuning configuration]