Re: SPAM-LOW: [GENERAL] cursors and ASP page

2006-10-12 Thread William Penberthy
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ANJANE Sent: Thursday, October 12, 2006 7:31 AM To: pgsql-general@postgresql.org Subject: SPAM-LOW: [GENERAL] cursors and ASP page I have a postgresql function defined as follows ... DECLARE int_userid ALIAS FOR $1; BEGIN OPEN $2 FOR SELEC

[GENERAL] cursors and ASP page

2006-10-12 Thread ANJANE
I have a postgresql function defined as follows ... DECLARE int_userid ALIAS FOR $1; BEGIN OPEN $2 FOR SELECT DISTINCT "users"."userloginid", "roles"."rolelike" FROM "roles" INNER JOIN "userpreferences" ON "roles"."roleid" = "userpreferences"."roleid" INNER JOIN "users" ON "use