Postgres Pro
Downloads
Home   >   mailing lists

Re: Error message with a SQL function - Mailing list pgsql-sql

From Tom Lane
Subject Re: Error message with a SQL function
Date
Msg-id 5657.1060442180@sss.pgh.pa.us
Whole thread Raw
In response to Error message with a SQL function  (proghome@silesky.com (krystoffff))
List pgsql-sql
Tree view 
proghome@silesky.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

pgsql-sql by date:

Previous
From: "Prasanth"
Date:
Subject: Re: Retrieving tuple data on insert
Next
From: Bruno Wolff III
Date:
Subject: Re: How to check: is some key referenced from sometable