| From: | Richard H <dev(at)archonet(dot)com> |
|---|---|
| To: | Marios Moutzouris <mariosm(at)netactive(dot)co(dot)za> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: rows equal |
| Date: | 2001-03-24 01:09:34 |
| Message-ID: | 20010324.1093400@client.archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 3/20/01, 7:23:04 PM, Marios Moutzouris <mariosm(at)netactive(dot)co(dot)za> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | datactrl | 2001-03-24 04:43:04 | how do I check if a temporary table exists? |
| Previous Message | pgsql-sql | 2001-03-23 23:22:32 | Re(2): trigger output to a file |