Received: from www-uk-05.digiserve.com ([195.97.231.11]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2OA4sw21062 for ; Sat, 24 Mar 2001 05:04:59 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id KAA23596; Sat, 24 Mar 2001 10:05:12 GMT Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 133C22A689; Sat, 24 Mar 2001 01:09:34 +0000 (GMT) From: Richard H Date: Sat, 24 Mar 2001 01:09:34 GMT Message-ID: <20010324.1093400@client.archonet.com> Subject: Re: rows equal To: Marios Moutzouris Cc: pgsql-sql@postgresql.org Reply-To: dev@archonet.com In-Reply-To: <998a7e$ppc$1@nnrp01.ops.uunet.co.za> References: <998a7e$ppc$1@nnrp01.ops.uunet.co.za> X-Mailer: Mozilla/3.0 (compatible; StarOffice/5.2;Linux) X-Priority: 3 (Normal) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f2OA5dw21246 X-Archive-Number: 200103/473 X-Sequence-Number: 2142 On 3/20/01, 7:23:04 PM, Marios Moutzouris wrote regarding [SQL] rows equal: > Hello > I need a sql query to a postgresql database which can tell me whether the > rows returned ar equal. > i.e > ------- > Status > ------- > Order > ------- > Collected > ---------- > This is two columns. Both are not equal. > Any help?.......without having to write code to fetch the result and go > through etc etc. Sorry - don't think so. Unless you've defined a unique index on one or more of these columns you'll have to check the contents of the columns. If they are never supposed to be the same, define a unique index. - Richard Huxton