Re: Error message with a SQL function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: proghome(at)silesky(dot)com (krystoffff)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error message with a SQL function
Date: 2003-08-09 15:16:20
Message-ID: 5657.1060442180@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

proghome(at)silesky(dot)com (krystoffff) writes:
> 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';

I don't believe there was a type "void" in PG 7.1. IIRC, back then the
custom was to say "RETURNS opaque" in this situation.

It's probably time for you to update to something newer ...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2003-08-09 16:01:13 Re: Comparing arrays
Previous Message Bruno Wolff III 2003-08-09 15:08:09 Re: How to check: is some key referenced from sometable