From: Michael Weaver <mweaver@corpusglobe.com>
To: Pgsql-Novice (pgsql-novice@postgresql.org) <pgsql-novice@postgresql.org>
To: 'Pgsql-SQL (pgsql-sql@postgresql.org)' <pgsql-sql@postgresql.org>
Subject: "function has no parameter $1" - help.
Date: Fri, 7 Feb 2003 16:10:29 +0800
Message-ID: <3B663B41B350D311AEEF00A0C9254563201A69@VISION1> (raw)
I'm trying to create a trigger to enforce a constraint onto two possible
foreign tables
my function is defined as:
<-- snip -->
CREATE OR REPLACE FUNCTION
sp_check_tranitem_productid(tbl_tranitem.fld_tranitem_id%TYPE,
tbl_tranitem.fld_tranitem_type%TYPE) RETURNS
OPAQUE AS '
DECLARE
-------[Parameters]-------
pl_product_id ALIAS FOR $1;
pl_product_type ALIAS FOR $2;
<-- snip -->
but when I call the function I get the error:
function has no parameter $1
What is going wrong?
(I am using PostgreSQL 7.3.1)
,
Mike Weaver
Software Developer
5, 42 Ladner Street
O'Connor, WA, 6163
All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA 6832
P: (+618) 9331 2700
F: (+618) 9331 3733
M: 0403 385 181
W: http://www.corpusglobe.com/
E: mweaver@corpusglobe.com
This email is intended only for the use of the individual or entity named
above and may contain information that is confidential. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this email is strictly prohibited. When addressed
to our clients, any opinions or advice contained in this email are subject
to the terms and conditions expressed in the governing Corpus Globe client
engagement letter. If you have received this Email in error, please notify
us immediately by return email or telephone +61 8 9331 2700 and destroy the
original message. Thank You.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mweaver@corpusglobe.com, pgsql-novice@postgresql.org
Subject: Re: "function has no parameter $1" - help.
In-Reply-To: <3B663B41B350D311AEEF00A0C9254563201A69@VISION1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox