Re: Create function errors

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Peck, Brian" <brian(dot)peck(at)lmco(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create function errors
Date: 2007-12-05 01:26:14
Message-ID: a55915760712041726x781ce41fm1d40d5518f4914ae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 4, 2007 6:04 PM, Peck, Brian <brian(dot)peck(at)lmco(dot)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 ).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wim Chalmet 2007-12-05 01:42:45 Re: Vacuum output redirect
Previous Message Merlin Moncure 2007-12-05 01:25:10 Re: Avoid huge perfomance loss on string concatenation