pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
rows equal
2+ messages / 2 participants
[nested] [flat]

* rows equal
@ 2001-03-20 19:23  Marios Moutzouris <mariosm@netactive.co.za>
  0 siblings, 1 reply; 2+ messages in thread

From: Marios Moutzouris @ 2001-03-20 19:23 UTC (permalink / raw)
  To: pgsql-sql

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.

thanks
marios





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: rows equal
@ 2001-03-24 01:09  Richard H <dev@archonet.com>
  parent: Marios Moutzouris <mariosm@netactive.co.za>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard H @ 2001-03-24 01:09 UTC (permalink / raw)
  To: Marios Moutzouris <mariosm@netactive.co.za>; +Cc: pgsql-sql

On 3/20/01, 7:23:04 PM, Marios Moutzouris <mariosm@netactive.co.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-24 01:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-20 19:23 rows equal Marios Moutzouris <mariosm@netactive.co.za>
2001-03-24 01:09 ` Richard H <dev@archonet.com>

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