cursors in postgres

From: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: cursors in postgres
Date: 2007-03-29 14:47:13
Message-ID: a47902760703290747r2dc5f9a2q6b1275392f042c36@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I've written a function using cursors as follows:
can anyone please comment on the text in red.

------------------------------------------------------

CREATE OR REPLACE FUNCTION sp_insert_tbl_email_address(int4, text, text,
text)
RETURNS void AS
$BODY$
DECLARE
uid int4 ;
src text;
local text;
domain text;
cur_dup_check CURSOR FOR SELECT * FROM tbl_email_address
WHERE unmask_id=$1 and source=$2 and email_local=$3 and email_domain=$4;

BEGIN

OPEN cur_dup_check ;

FETCH cur_dup_check INTO uid,src,local,domain;
--need to check the fetch status of the cursor whether any rows were
returned or not and keep moving to the next record till fetch status is not
zero

INSERT INTO tbl_email_address(unmask_id,source,email_local,email_domain)

VALUES ($1,$2,$3,$4) ;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION sp_insert_tbl_email_address(int4, int4, text, text, text)
OWNER TO postgres;

-----------------------------------------------------

Thanks,
~Jas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2007-03-29 15:03:44 Re: cursors in postgres
Previous Message Richard Huxton 2007-03-29 13:51:27 Re: RES: Order by behaviour