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
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco