From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: different results from plpgsql functions related to last changes in master |
Date: | 2018-02-18 16:51:56 |
Message-ID: | CAFj8pRAHu+1U1wzHwQgJCzb8XvH4fEwNEWEPRXrEBcTdS0i_Rw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2018-02-18 17:48 GMT+01:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> > I did update of plpgsql_check and I see, so some functions returns
> > different result than on older posgresql. Probably this is wanted behave,
> > but It should be mentioned as partial compatibility break, because some
> > regress test can be broken too.
>
> This is mentioned in the relevant commit message (4b93f5799):
>
> ... A lesser, but still real, annoyance is that ROW format cannot
> represent a true NULL composite value, only a row of per-field NULL
> values, which is not exactly the same thing.
>
> In the case you're showing here, a true NULL got changed into ROW(NULL)
> by the old code, but that no longer happens.
>
I understand, and I have not any problem with this behave. Just I am
expecting so lot of people will be surprised.
Regards
Pavel
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Dolgov | 2018-02-18 17:49:20 | Re: [HACKERS] Bug in to_timestamp(). |
Previous Message | Tom Lane | 2018-02-18 16:48:56 | Re: different results from plpgsql functions related to last changes in master |