Hi Ken -
On Thu, Feb 22, 2018 at 10:24 AM, Ken Tanzer wrote:
> On Thu, Feb 22, 2018 at 1:09 AM, Alexander Farber <
> alexander.far...@gmail.com> wrote:
>
>> Good morning, there are these 2 records in a table:
>>
>> # select m.played, m.mid, m.action, m.gid, m.uid from words_moves m where
>> gid=
On Thu, Feb 22, 2018 at 1:09 AM, Alexander Farber <
alexander.far...@gmail.com> wrote:
> Good morning, there are these 2 records in a table:
>
> # select m.played, m.mid, m.action, m.gid, m.uid from words_moves m where
> gid=10;
> played | mid | action | gid | uid
> ---
Ahh, thank you Laurenz -
On Thu, Feb 22, 2018 at 10:18 AM, Laurenz Albe
wrote:
>
> You are only checking if there is a later timestamp *for the same "mid"*.
>
> Since the two rows have different "mid", they are not compared.
>
no it works -
# select m.played, m.mid, m.action, m.gid, m.uid from
s/no it works/now it works/
Alexander Farber wrote:
> Good morning, there are these 2 records in a table:
>
> # select m.played, m.mid, m.action, m.gid, m.uid from words_moves m where
> gid=10;
> played | mid | action | gid | uid
> ---+-++-+-
> 2018-02
Good morning, there are these 2 records in a table:
# select m.played, m.mid, m.action, m.gid, m.uid from words_moves m where
gid=10;
played | mid | action | gid | uid
---+-++-+-
2018-02-19 14:42:08.46222+01 | 12 | play |
