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