Re: Can someone tell me why this statement is failing?
От | denis@coralindia.com |
---|---|
Тема | Re: Can someone tell me why this statement is failing? |
Дата | |
Msg-id | 007101c4277e$18a5d420$3332a8c0@DENIS обсуждение исходный текст |
Ответ на | Can someone tell me why this statement is failing? (P A <patkins2474@yahoo.com>) |
Список | pgsql-sql |
Hi.. Your END_TIME_MINUTES condition fails.. 1082377320 <= 1082375100 HTH. Denis ----- Original Message ----- From: P A <patkins2474@yahoo.com> To: <pete@tkins.com> Cc: <pgsql-sql@postgresql.org> Sent: Tuesday, April 20, 2004 2:01 AM Subject: [SQL] Can someone tell me why this statement is failing? > 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
В списке pgsql-sql по дате отправления: