Re: Order by and timestamp - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Order by and timestamp
Date
Msg-id 20195383-f8ae-9b48-9a8e-dd19f6efb8b4@aklaver.com
Whole thread Raw
In response to Re: Order by and timestamp  (Björn Lundin <b.f.lundin@gmail.com>)
List pgsql-general
On 3/16/20 2:50 PM, Björn Lundin wrote:

> 
> But not for that data sep/oct 2016

Had a thought, what if on the ibm2 machine you do:

UPDATE amarkets SET  startts = '2016-09-30 13:00:00' WHERE
  marketid = 1.127278857;

And then rerun:

select * from amarkets order by startts;


> 
> 
>> Yes really, otherwise you would not be seeing a difference. Sorry, pet 
>> peeve of mine, when people say these two things are not doing the same 
>> thing but then say they are the same thing.
>>
>>> I mean, the pg_dump does copy-commands.
>>
>> It also does a certain amount of setup at the beginning of the file.
> 
> I stand corrected
> 
> --
> Björn Lundin
> b.f.lundin@gmail.com <mailto:b.f.lundin@gmail.com>
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Order by and timestamp
Next
From: Samuel Smith
Date:
Subject: Re: Invalid byte sequence errors on DB restore