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<[email protected]> 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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
