Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA17002
	for <pgsql-interfaces@hub.org>; Sat, 1 May 1999 12:18:52 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id MAA01466;
	Sat, 1 May 1999 12:18:05 -0400 (EDT)
To: Peter Garner <peter_garner@yahoo.com>
cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Some needed features in postgresql 
In-reply-to: Your message of Fri, 30 Apr 1999 16:37:24 -0700 (PDT)
	<19990430233724.1105.rocketmail@web216.mail.yahoo.com>
Date: Sat, 01 May 1999 12:18:04 -0400
Message-ID: <1464.925575484@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Peter Garner <peter_garner@yahoo.com> writes:
> 1.  Does postgres support the minus operator.  It does
> not seem that I can query :

> select text_field from table_1
> minus
> select text_field from table_2

The standard-approved spelling is "EXCEPT", and support for it is new in
6.5.  It could probably use some more beta testing, so please try it...

> 2.  Is there any work being done on the fact that
> transactions are aborted when an error occurs?  It
> really lessens the usefulness of the product when,
> after adding 20,000 records, the transaction aborts
> because the 20,001th record is a dup key! :-)

I've griped about that myself in the past, but it's not real
clear how else it ought to work.  Maybe you should be using
smaller transactions ;-)

> Please accept my apologies if this should have gone
> to the hackers list.

I'd say the pgsql-sql list would be the best place for this kind of
question.  It's off-topic for the interfaces list, for certain.

			regards, tom lane