Received: from access1.lan2wan.com (bmccoy@access1.lan2wan.com [205.177.8.10]) by hub.org (8.9.2/8.9.1) with ESMTP id MAA36353 for ; Wed, 3 Mar 1999 12:28:57 -0500 (EST) (envelope-from bmccoy@access1.lan2wan.com) Received: (from bmccoy@localhost) by access1.lan2wan.com (8.8.5/) id PAA07031; Wed, 3 Mar 1999 15:02:50 -0500 (EST) Date: Wed, 3 Mar 1999 15:02:50 -0500 (EST) From: "Brett W. McCoy" To: pgsql-sql@postgreSQL.org Subject: return types in functions Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I have a function that inserts to columns into a table based upon the result of a query from another table. The problem is, I can't seem to figure out what the proper return type is for this function. Since it doesn't retrieve anything, I can't return anything like that. Here's the function creation statement (without the return type): CREATE FUNCTION insert_unknown_mfr(varchar) RETURNS ?? AS 'INSERT INTO unknown_mfr SELECT DISTINCT manufacturer, drugname FROM drugs WHERE manufacturer = $1' LANGUAGE 'sql; Brett W. McCoy http://www.lan2wan.com/~bmccoy ----------------------------------------------------------------------- Accuracy, n.: The vice of being right ----- BEGIN GEEK CODE BLOCK ----- Version: 3.12 GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N- o K- w--- O@ M-@ !V PS+++ PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ e>++ h+ r++ y++++ ------ END GEEK CODE BLOCK ------