[postgis-users] isnumeric function

[Alexandre Dube]

Hi Paul,

  Yep, that was it.  Thanks again for your help,

Alexandre

Paul Ramsey wrote:
> See how the $1 is missing in your error message? The shell is eating
> that. Try escaping the $ characters with a \ in your shell call.
>
> On Wed, Jun 10, 2009 at 12:29 PM, Alexandre Dube<adube at mapgears.com> wrote:
>   
>>  Here's what I tried and didn't work :
>>
>> psql -d mydb -c "CREATE FUNCTION isnumeric(text) RETURNS boolean AS 'SELECT
>> $1 ~ ''^[0-9]+$'' ' LANGUAGE 'sql'"
>>
>>     


-- 
Alexandre Dubé
Mapgears
www.mapgears.com