From: Richard Broersma Jr <rabroersma@yahoo.com>
To: christian.roche.ext@nsn.com
To: pgsql-sql@postgresql.org
Subject: Re: Whole-row comparison ?
Date: Thu, 17 May 2007 06:38:26 -0700 (PDT)
Message-ID: <457481.33047.qm@web31807.mail.mud.yahoo.com> (raw)
In-Reply-To: <CCC9DCA122011F4CA593F6A548BFFBD354D217@esebe111.NOE.Nokia.com>
> So my question is: is there a way to do some kind of whole-row
> comparison ? For instance a hash of the full row or something similar ?
> Is there a standard way of solving this problem ?
Sure it is called row wise comparison:
http://www.postgresql.org/docs/8.2/interactive/functions-comparisons.html#ROW-WISE-COMPARISON
you can write something like:
SELECT *
FROM Your_table
WHERE (c1,c2,c3,c4) = ('a',2,'xyz',123);
Regards,
Richard Broersma Jr.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, christian.roche.ext@nsn.com
Subject: Re: Whole-row comparison ?
In-Reply-To: <457481.33047.qm@web31807.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox