Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1AJhtx80804 for ; Sat, 10 Feb 2001 14:43:55 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.3) with HTTP id 1189015; Sat, 10 Feb 2001 11:43:49 -0800 From: "Josh Berkus" Subject: 16 Argument Limit ?!?!? To: pgsql-sql@postgresql.org Cc: jeff@pgsql.com X-Mailer: CommuniGate Pro Web Mailer v.3.3 Date: Sat, 10 Feb 2001 11:43:49 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/195 X-Sequence-Number: 1382 Tom, Jan, After spending an entire day writing and debugging a particularly complex PLPGSQL function, I just received this error: Procedures Cannot Take More than 16 Arguments. This is a truly devastating blow to my application (which is already behind schedule, needless to say). I've been using Functions to control all mods and additions to the program's data tables. I guess I just haven't had to wirte a function for a table with more than 16 columns yet. The current function uses 36 parameters, 3 of which are arrays. Is there any way around this? Maybe something using the RECORD data type? Can anyone help me with an explanation of the RECORD data type and how to get data into and out of it? -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco