This cannot be.
I have tested this.
Do you have a table named films?

Are there rows in it?

I was testing this on 7.2.1 in RH7.2

Is there a script that executes this statemtns or do you type it manuallly in psql?

I am running it through pgadmin II SQL query screen. I will try it from the command prompt.

Thanks

Dave

EDIT: Ok it works fine at the psql level.

So now my question is how do I return that recordsetup to the calling application level?

What do you want exactly?

begin work;
declare cursor ...

FETCH FORWARD 5 cursor;

commit;

get the rows of the fetch?

Originally posted by eperich
What do you want exactly?

begin work;
declare cursor ...

FETCH FORWARD 5 cursor;

commit;

get the rows of the fetch?

Yes. Ideally I would like to contain the entire thing in a function and return a pointer to a cursor that contains the recordset but failing that yes that is exactly what I want to do.

I don't know how you can achieve this but I think only way is that this fetch is the same as a select and you can get the data in the same way as you can get it from select.

I'm no ASP and ODBC guru so I can't test this theory
:D

ok so at the psql level how do I make this a function and return only the cursor object.

The crux of the problem is a limited amount of data that ODBC will pass ( 2K I think ) and my queries would exceed that.

Thanks again.

Dave

now I understand you want to return the referenc of the cursor from the function

Sorry. I don't know if this is possible.

The only chance you have is to post an entry in the pgsql-sql list.
Josh Berkus may know this. I think he is the pl/pgsql expert

Originally posted by eperich
now I understand you want to return the referenc of the cursor from the function

Sorry. I don't know if this is possible.

The only chance you have is to post an entry in the pgsql-sql list.
Josh Berkus may know this. I think he is the pl/pgsql expert

Ok. great thank you for all your help.

One last question :)

Where do I find the pgsql-sql list? I have been all over the web and postgresql documentation is all over the place but mostly redundant. So just to avoid me finding 3000 identical locations calling themselves a pgsql-sql list could you give me a primary url to register and post at.

Thanks again.

Dave

usenet below :D
comp.databases.postgresql.sql

or the mailing list

Lists near the bottom of the page (http://www.de.postgresql.org/users-lounge/index.html)