From: | chris mutchler <davron(at)leibnizcreations(dot)com> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | EXCEPT call not working |
Date: | 2000-09-07 21:00:30 |
Message-ID: | Pine.BSF.4.10.10009071457430.14802-100000@leibnizcreations.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a perl script that interacts with my postgresql server through the
DBI module. When, I send my query to the server it will work fine with
the following:
$sth = $dbh->prepare("
SELECT p.ids_name, m.start_time, m.end_time
FROM mail_schedule m, personnel p
WHERE p.ids_int = m.ids_int AND
m.dow = $weekday
UNION
SELECT p.ids_name, c.on_start, c.on_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int
");
But as soon as I place the EXCEPT call in there it stops working and
doesn't return any values:
$sth = $dbh->prepare("
SELECT p.ids_name, m.start_time, m.end_time
FROM mail_schedule m, personnel p
WHERE p.ids_int = m.ids_int AND
m.dow = $weekday
UNION
SELECT p.ids_name, c.on_start, c.on_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int
EXCEPT
SELECT p.ids_name, c.on_start, c.on_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int
AND c.on_start = 0
AND c.on_end = 0
");
Does anyone have any suggestions as to why my EXCEPT call isn't working?
If you see some drastic or subtle syntax error let me know. I have never
used EXCEPT before, and am not having much luck. thanks.
Chris Mutchler
davron(at)leibnizcreations(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-09-07 21:08:55 | Re: php and pgsql and rpm/compile |
Previous Message | The Hermit Hacker | 2000-09-07 19:59:51 | Re: That killer 3rd join... |