Re: AW: Re: [INTERFACES] USE OF CURSORS IN ECPG - Mailing list pgsql-hackers

From Christof Petig
Subject Re: AW: Re: [INTERFACES] USE OF CURSORS IN ECPG
Date
Msg-id 3A0BEEDD.530A3557@wtal.de
Whole thread Raw
In response to AW: Re: [INTERFACES] USE OF CURSORS IN ECPG  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Zeugswetter Andreas SB wrote:

> > PS: You might consider applying the patch for (update where > not_found) -> 100
>
> No, this is not allowed. sqlcode is supposed to be 0 in above case.
> You need to explicitly check for the number of rows updated in your
> program if needed.
>
> Andreas

According to my reading of the SQL standard this is the only compliant behaviour. Do
you know better?

Christof




pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: [INTERFACES] USE OF CURSORS IN ECPG
Next
From: Tom Lane
Date:
Subject: Re: Must a C state transition function use palloc on the returned value?