Error message with a SQL function

From: proghome(at)silesky(dot)com (krystoffff)
To: pgsql-sql(at)postgresql(dot)org
Subject: Error message with a SQL function
Date: 2003-08-08 14:13:28
Message-ID: 85898f7e.0308080613.6cfb3e7c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

I try to create the following SQL function:

CREATE FUNCTION update_affiliate(int,double precision,double
precision) RETURNS void AS ' UPDATE affiliate SET balance=balance +
$2, balance_in_points=balance_in_points + ( $2 / $3 ) WHERE id = $1; '
LANGUAGE 'sql';

but when I submit this query directly with PostgreSQL, I have the
following error message:

PostgreSQL said: ERROR: Unable to locate type oid 325664 in catalog

I think the problem comes from the first parameter ($1) but I don't
understand because affiliate.id is indeed the primary key of the table
affiliate.

Has anybody an idea ?
Thanks
Krystoffff

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jonathan Gardner 2003-08-08 15:29:36 Re: duplicate dates
Previous Message BenLaKnet 2003-08-08 08:13:59 [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3