pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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