I am a novice to PostgreSQL (although I know ORACLE's PL/SQL very well)
I have written a Stored Function in PostgreSQL but cannot figure out how
to compile it or run it in PostgreSQL. In ORACLE, one would have to
do this at SQL*PLUS prompt : @<file-path\file_name to compile the stored
function into ORACLE DB.
In PostgreSQL, how do I do that?
In ORACLE, one would have to write a PL/SQL to test the stored function
(and use DBMS_OUTPUT.PUT_LINE) to get the stored function to write to
In PostgreSQL, how do I test the stored function? I noticed none of the
documentation or books seemed to mention this simple point.
pgsql-novice by date
|Next:||From: Christoph Della Valle||Date: 2006-07-17 10:13:27|
|Subject: Re: RE : How do I compile/test a PL/SQL in Postgresql|
|Previous:||From: Tom Lane||Date: 2006-07-14 19:15:51|
|Subject: Re: PQexecParams and PQexecPreparaed |