Re: [GENERAL] Confused by misleading error message on SP creation

2007-01-09 Thread Gregory S. Williamson
Subject:Re: [GENERAL] Confused by misleading error message on SP creation On Tue, Jan 09, 2007 at 03:42:47AM -0800, Gregory S. Williamson wrote: > This is PostgreSQL 8.1.4, and I am utterly lost. > The error message: > psql:e.sql:54: ERROR: syntax error at or near "$2&qu

Re: [GENERAL] Confused by misleading error message on SP creation

2007-01-09 Thread Martijn van Oosterhout
On Tue, Jan 09, 2007 at 03:42:47AM -0800, Gregory S. Williamson wrote: > This is PostgreSQL 8.1.4, and I am utterly lost. > The error message: > psql:e.sql:54: ERROR: syntax error at or near "$2" at character 15 > QUERY: SELECT $1 $2 := $3 > CONTEXT: SQL statement in PL/PgSQL function "