Re: Order by and timestamp

On 3/15/20 2:33 PM, Björn Lundin wrote:
> Hi!
> I have an old database that behaves a bit strange.
> I keeps horse races in UK/IE.
> I have a program that continuously* adds record into a market table ,
> described as below.
> 
> *continuously means ’after each race’ which is ca 12:00 --> 23:00.
> 
> I then did ’select * from AMARKETS order by STARTTS’

Is amarkets in more then one schema?

If so what is search_path?

I could not replicate the below.

What does below show?:

select '2016-09-30 13:00:00'::timestamp at time zone 'UTC';

select '2016-10-01 15:35:00'::timestamp at time zone 'UTC';



> 
> And to my surprise i get a result like this  (note the order of column 
> STARTTS)
> 
>    marketid   |        marketname        |       startts       | eventid
> ….
> ….
> 

>   1.127275701 | To Be Placed             | 2016-10-01 14:25:00 | 27953172 |
>   1.127275705 | 1m Grp1                  | 2016-10-01 15:00:00 | 27953172 |
>   1.127275708 | To Be Placed             | 2016-10-01 15:00:00 | 27953172 |
>   1.127275715 | To Be Placed             | 2016-10-01 15:35:00 | 27953172 |
>   1.127275722 | To Be Placed             | 2016-10-01 16:10:00 | 27953172 |
>   1.127278857 | 7f Hcap                  | 2016-09-30 13:00:00 | 27953255 |
>   1.127278858 | To Be Placed             | 2016-09-30 13:00:00 | 27953255 |
>   1.127278862 | 1m Class Stks            | 2016-09-30 13:35:00 | 27953255 |
>   1.127278863 | To Be Placed             | 2016-09-30 13:35:00 | 27953255 |
>   1.127278867 | 6f Hcap                  | 2016-09-30 14:10:00 | 27953255 |
> …
> ….

> 
> 
> regards
> --
> Björn Lundin
> b.f.lundin@gmail.com <mailto:b.f.lundin@gmail.com>
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com