X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1FB3AD1C9BA for ; Sat, 9 Aug 2003 15:16:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 79199-01 for ; Sat, 9 Aug 2003 12:15:05 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 2AA1BD1C514 for ; Sat, 9 Aug 2003 12:16:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h79FGKSa005658; Sat, 9 Aug 2003 11:16:20 -0400 (EDT) To: proghome@silesky.com (krystoffff) Cc: pgsql-sql@postgresql.org Subject: Re: Error message with a SQL function In-reply-to: <85898f7e.0308080613.6cfb3e7c@posting.google.com> References: <85898f7e.0308080613.6cfb3e7c@posting.google.com> Comments: In-reply-to proghome@silesky.com (krystoffff) message dated "08 Aug 2003 07:13:28 -0700" Date: Sat, 09 Aug 2003 11:16:20 -0400 Message-ID: <5657.1060442180@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/84 X-Sequence-Number: 14700 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