Re: [SQL] Help writing a piece of SQL

2006-02-03 Thread Nigel Bishop
Niklas, Thank you very much, that did the business Cheers Nigel Bishop -Original Message- From: Niklas Johansson [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 13:00 To: Nigel Bishop Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Help writing a piece of SQL On 3 feb 2006, at

Re: [SQL] Help writing a piece of SQL

2006-02-03 Thread Nigel Bishop
Thanks for that Richard, it's almost what I'm after: So where the un and dm exist then return 1 row Where the un doestn't exist and dm does then return all sendtos' where the dm exists not just where the un='*' I hope that makes sense. Thanks for you help Nigel

[SQL] Help writing a piece of SQL

2006-02-03 Thread Nigel Bishop
Hi, I would appreciate some help writing a piece of SQL   PG803   My table/data looks like this:   username |    domain     |    sendto    +-+---+--  Postmaster   | intthit0