On Tue, Oct 11, 2005 at 07:24:12PM +0200, Rafael Montoya wrote:
> I'm migrating some triggers from oracle to postgresql and i can´t find the
> equivalent of the following two sentences:
> 1)
> DECLARE
> TMP_COD_PRO PRODUCT.COD_PRO%TYPE;
See "Declarations" in the PL/pgSQL documentation for th
I'm migrating some triggers from oracle to postgresql and i can´t find the
equivalent of the following two sentences:
1)
DECLARE
TMP_COD_PRO PRODUCT.COD_PRO%TYPE;
I don't know if its equivalent exists in PostgreSQL
2)
EXCEPTION
when no_data_found then null;
what i tried :
exceptio
On Thu, Aug 11, 2005 at 10:15:11AM -0400, Jeff Boes wrote:
> How does one raise an exception from a PL/Perl function? Specifically,
> this is a trigger function. Is it as simple as "die "?
Use elog:
http://www.postgresql.org/docs/8.0/static/plperl-database.html
--
Michael Fuhr
On Thu, Aug 11, 2005 at 10:15:11AM -0400, Jeff Boes wrote:
> How does one raise an exception from a PL/Perl function?
> Specifically, this is a trigger function. Is it as simple as "die
> "?
elog(ERROR, $errmsg)
works.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510
How does one raise an exception from a PL/Perl function? Specifically,
this is a trigger function. Is it as simple as "die "?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
