> "Олег" == Олег Самойлов writes:
Олег> Hi, all.
Олег> I got some mystic behaviour of PostgreSQL, perhaps this is a bug.
Feature, actually.
Олег> But things begin be strange if I add validation by time.
Олег> => explain select * from node as parent left join link on
Олег> parent.node_
På onsdag 16. januar 2019 kl. 11:54:21, skrev Олег Самойлов mailto:spl...@ya.ru>>:
Hi, all.
I got some mystic behaviour of PostgreSQL, perhaps this is a bug.
[snip]
But things begin be strange if I add validation by time.
=> explain select * from node as parent left join link on
parent.nod
Hi, all.
I got some mystic behaviour of PostgreSQL, perhaps this is a bug.
Tables is a model of a simple graph where parents and children related as «many
to many». And there is a field «valid» to validate for current moment.
set search_path = 'left_join';
begin;
drop schema if exists left_join
