Re: [SQL] Returning a reference to a cursor from a function

2002-09-18 Thread david williams
: Richard Huxton Sent: Wednesday, September 18, 2002 6:32 AM To: david williams Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Returning a reference to a cursor from a function  On Tuesday 17 Sep 2002 7:12 pm, you wrote:> Richard,>> Thanks for the information. I've made some modifications to

Re: [SQL] Returning a reference to a cursor from a function

2002-09-18 Thread Richard Huxton
On Tuesday 17 Sep 2002 7:12 pm, you wrote: > Richard, > > Thanks for the information. I've made some modifications to your code here > so that it does a RAISE NOTICE in each loop returning simply the value of n > and then when the loop is finished it again returns n. > > This works fine at the psq

Re: [SQL] Returning a reference to a cursor from a function

2002-09-17 Thread Richard Huxton
On Thursday 12 Sep 2002 7:12 pm, david williams wrote: > To anyone who can help me, > > I am new at Postgresql and am having some problems. > I went a stage further attempt to put this query into a function as such > CREATE FUNCTION getallusers() RETURN integer AS' > DECLARE > Liahona CURSOR