Cursor bug?

From: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cursor bug?
Date: 2005-01-13 20:44:30
Message-ID: 20050113204430.GA15895@thegodshalls.thegodshalls
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a function that reads through one table via a cursor to make updates to a different table. There is a row in this table with a column that has a null value. The following row, in that same column, is not null.

When the cursor loops through the table it seems to be treating the non null row as being null. The fetch should be inserting the new non value into the variable but doesn't appear to be.

I have attached. pg_dump of original table (knocked it down to three rows).
pg_dump of destination table
File with function
File to execute function and see result

Shouldn't the destination table have 2 rows instead of just the one.

Any help on what I might be overlooking would be appreciated.

Attachment Content-Type Size
cursor_bug.zip application/zip 26.3 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2005-01-13 20:55:09 Re: Functions returning RECORD
Previous Message Pavel Stehule 2005-01-13 20:41:23 Re: Functions returning RECORD