| From: | garry saddington <garry(at)schoolteachers(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | odd result set |
| Date: | 2006-11-15 04:29:58 |
| Message-ID: | 1163564998.21067.3.camel@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have the following result from the sql below. Can anyone help by
explaining why the last record could be returned. Periodstart and
periodend are time data types. I have tried to cast '10.35' to a time
type with the same results.
________________________________________________________________________
Periodid
Periodnumber
Periodstart
Periodend
1
1
09:00:00.00
09:35:00.00
2
2
09:35:00.00
09:10:00.00
3
3
10:20:00.00
10:55:00.00
4
4
10:50:00.00
11:30:00.00
________________________________________________________________________
SQL used:
select * from periods
where '10:35' > periodstart
Kind regards
Garry
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed L. | 2006-11-15 04:55:48 | autovac state persistence |
| Previous Message | Desmond Coughlan | 2006-11-15 02:54:29 | RE : Re: RE : Re: database design ... |