Re: [BUGS] BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field

2007-11-21 Thread Eugene Hutorny
This 'feature' makes such a view unusable in the clients (MS Access or any other ADO based) that *do verify* update count and report an error if it is not of expected value. Is there a workaround for this? Peter, you mentioned it is documented, may you please point me to the document you meant? -

Re: [BUGS] BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1

2007-09-21 Thread Eugene Hutorny
I expect 0 because SELECT EXTRACT(YEAR FROM INTERVAL '1 day'), EXTRACT(MONTH FROM INTERVAL '1 day') returns 0,0 - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Eugene M. Hutorny" <[EMAIL PROTECTED]> Cc: Sent: Friday, September 21, 2007 7:21 PM Subject: Re: [BUGS] BUG #36