Received: from web12506.mail.yahoo.com (web12506.mail.yahoo.com [216.136.173.198]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3C4GH827705 for ; Thu, 12 Apr 2001 00:16:17 -0400 (EDT) (envelope-from lonnie_cumberland@yahoo.com) Message-ID: <20010412041617.71469.qmail@web12506.mail.yahoo.com> Received: from [141.217.140.65] by web12506.mail.yahoo.com; Wed, 11 Apr 2001 21:16:17 PDT Date: Wed, 11 Apr 2001 21:16:17 -0700 (PDT) From: Lonnie Cumberland Subject: Calling plSQL functions To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200104/172 X-Sequence-Number: 2520 Hello All, I have created a plSQL function with the "create function ..." which seems to be ok and is just very simple. I then wanted to load the function by: psql -f test.sql -d trdata which loads my function fine. the problem is that I do not know how to call this function from the PLSQL interpreter. I tried "select reg_user('name','age');" but it just gives me an error about an unexpected "select ..." I am writing some plSQL functions and also some "C" interface functions that I want to load and then call from with the interpreter. Any ideas? cheers, Lonnie __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/