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