Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > On 3/15/20 2:33 PM, Björn Lundin wrote: >> I then did ’select * from AMARKETS order by STARTTS’ > Is amarkets in more then one schema? Yeah, it's hard to think of any explanation other than "the query used a corrupt index on startts to produce the ordering". But your \d doesn't show any index on startts. So maybe there's more than one amarkets table? Another possibly-useful bit of evidence is to see what EXPLAIN shows as the query plan for this query. regards, tom lane
