Re: Calling plSQL functions

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