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      [EMAIL PROTECTED]
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to