;
That will fix your issue.
-Chandra Sekhar Surapaneni
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jasbinder Singh
Bali
Sent: Friday, February 09, 2007 11:30 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Some unknown error in a function
Hi
Following is the
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> I run this function using
> select sp_insert_tbl_vrfy_mx(55,'jas','xyz.com','192.168.0.105', '
> mail.xyz.com,'mxrecoredmxjdlkfjdk')
> and get the following error:-
> CONTEXT: SQL statement "SELECT $1 =' '"
> PL/pgSQL function "sp_insert_tbl
Hi
Following is the script of my plpgsql function
CREATE OR REPLACE FUNCTION sp_insert_tbl_vrfy_mx(int4,text, text, inet,
text, text)
RETURNS void AS$$
DECLARE
sequence_no int4;
BEGIN
SELECT INTO sequence_no MAX(seq_no) FROM tbl_verify_mx WHERE unmask_id =
$1;
IF sequence_
