This is PostgreSQL 8.1.4, and I am utterly lost.
This function started in Informix and worked perfectly. Migrating to postgres
resulted in about a *10,000* x slow down as it resorts to doing a sequential
scan. In the sql below the addition of client id and report id to the initial
select are
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.
snip
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
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.
snip
The error message:
psql:e.sql:54: ERROR: syntax error at or near $2 at character 15
QUERY