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 f3CEJQ898731 for ; Thu, 12 Apr 2001 10:19:26 -0400 (EDT) (envelope-from lonnie_cumberland@yahoo.com) Message-ID: <20010412141601.58926.qmail@web12506.mail.yahoo.com> Received: from [141.217.140.65] by web12506.mail.yahoo.com; Thu, 12 Apr 2001 07:16:01 PDT Date: Thu, 12 Apr 2001 07:16:01 -0700 (PDT) From: Lonnie Cumberland Subject: Re: Calling plSQL functions To: Josh Berkus Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200104/175 X-Sequence-Number: 2523 I solved the problem Josh. It had to do with the "select ..." statement in the function and also I needed to include a "record" variable so the the "select into " could act upon. Thanks for the help anyway. Cheers, Lonnie --- Josh Berkus wrote: > Lonnie, > > It may be that you have not linked the PL/pgSQL language in Postgres. > > It may be that you are putting a SELECT statement inside your function. > > It is hard to tell, becuase I am unclear on the problem youa re having, > exactly. Here's some terminology to help clarify: > > PL/pgSQL is the extension of SQL written by Jan Wieck used to write > functions in PostgreSQL. > > PSQL is the command-line interface tool for the PostgreSQL database. > > PL/SQL is a procedure-writing language for Oracle which does not work on > PostgreSQL at all, although it was the inspiration for PL/pgSQL. > > Please re-state you difficulty, and I can probably help you. > > -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 __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/