On 11/23/21 10:41, Isaac Morland wrote:
> Umm, it's definitely negative:
>
> odyssey=> select '1 month -31 days +12:00:00'::interval < '0
> months'::interval;
> --
> t
Well, what you've shown here is that it's "negative" according to
an arbitrary total ordering imposed in interval_cmp_va
On Tue, 23 Nov 2021 at 09:44, Chapman Flack wrote:
> On 11/23/21 02:29, Ilya Anfimov wrote:
> > (*We
> > strangely don't have an absolute value operator on interval, but
> > I think you've got the point*).
>
> Although tangential to the topic, that might be because a PG interval
> is a triple of
On 11/23/21 02:29, Ilya Anfimov wrote:
> (*We
> strangely don't have an absolute value operator on interval, but
> I think you've got the point*).
Although tangential to the topic, that might be because a PG interval
is a triple of independently-signed months/days/seconds components.
An interval
On Mon, Nov 22, 2021 at 03:44:37PM +0300, Alexander Kuzmenkov wrote:
> On 21.11.2021 07:53, Ilya Anfimov wrote:
> > DISCLAIMER: I am both seeing this first time and I don't have a
> > good understanding of the PosgreSQL development practices.
>
> > pure evil
> > ridiculous
> No worries, at least
On 21.11.2021 07:53, Ilya Anfimov wrote:
DISCLAIMER: I am both seeing this first time and I don't have a
good understanding of the PosgreSQL development practices.
pure evil
ridiculous
No worries, at least you got the etiquette just right.
There are two points in your mail that I'd like t
>But anyways this looks like just a syntactic sugar. LATERAL
>JOINS should logically work just fine. Any optimisation should
>deal with the LATERAL syntax style anyway.
Agreed.
However, if a rewrite is implemented, it then becomes encoded into
PostgreSQL code what ASOF maps to. Anyone who
On Thu, Nov 18, 2021 at 05:11:16PM +0300, Alexander Kuzmenkov wrote:
> Hi hackers,
>
> There was some interest in implementing ASOF joins in Postgres, see
> e.g. this prototype patch by Konstantin Knizhnik:
> https://www.postgresql.org/message-id/flat/bc494762-26bd-b100-e1f9-a97901ddad57%40postgre
Hi hackers,
There was some interest in implementing ASOF joins in Postgres, see
e.g. this prototype patch by Konstantin Knizhnik:
https://www.postgresql.org/message-id/flat/bc494762-26bd-b100-e1f9-a97901ddad57%40postgrespro.ru
I't like to discuss the possible ways of implementation, if there is
st