SELECT * FROM ... WHERE ... AND (end_time_minutes IS NULL OR end_time_minutes <= '1082375100');
or
SELECT * FROM ... WHERE ... AND coalsece(end_time_minutes, 0) <= '1082375100';
P A wrote:
Can anyone tell me why this SQL statement is not matching with the row from the table below? I think I'm going mad!
##################################### SQL Statement #####################################
SELECT * FROM t_bell_schedule WHERE calendar_day = '2004-04-12' AND start_time_minutes >= '1082374200' AND end_time_minutes <= '1082375100';
##################################### Current DB Data to match #####################################
calendar_day | period_letter | start_time_minutes |
end_time_minutes
--------------+---------------+--------------------+------------------
2004-04-12 | B | 1082374440 | 1082377320
#####################################
DB Structure #####################################
Column | Type | Modifiers
--------------------+-----------------------------+---------------------------------------------------------------------------------
bell_schedule_uid | integer |
not null default
nextval('public.t_bell_schedule_bell_schedule_uid_seq'::text)
calendar_day | date |
period_letter | character varying(4) |
period | character varying(4) |
start_time | time without time zone |
end_time | time without time zone |
total_minutes | integer |
activestatus | integer |
datecreated | timestamp without time zone |
datemodified | timestamp without time zone |
start_time_minutes | integer |
end_time_minutes | integer |
Cheers, Pete
__________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
-- Edmund Bacon <[EMAIL PROTECTED]>
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
