Home > mailing lists

[HACKERS] remove unnecessary flag has_null from PartitionBoundInfoData - Mailing list pgsql-hackers

From	Jeevan Ladhe
Subject	[HACKERS] remove unnecessary flag has_null from PartitionBoundInfoData
Date	May 17, 2017 16:53:50
Msg-id	CAOgcT0NZ_30-pjBpW2OgneV1ammArHkZDZ8B_KFC3q+_Xb2H9A@mail.gmail.com Whole thread Raw
Responses	Re: [HACKERS] remove unnecessary flag has_null from PartitionBoundInfoData (Robert Haas <robertmhaas@gmail.com>)
List	pgsql-hackers

Hi,

As discussed in default partition thread[1], here is the patch to remove

has_null from PartitionBoundInfoData structure.

Basically flag has_null is not needed and null_index can be checked if the

current bound is having a null value or not.

For simplicity of future use, in attached patch I have introduced a macro that

would return TRUE if the given bound has null.

PFA.

[1]. https://www.postgresql.org/message-id/CAFjFpRcvD-jf6z6-5mjx4tm-8NSj8Wnh%2B6%3DL6OB9Qy2yKX0HCg%40mail.gmail.com

Regards,

Jeevan Ladhe

Attachment

remove_has_null_PartitionBoundInfoData_v1.patch

pgsql-hackers by date:

Previous

From: Dilip Kumar
Date: 17 May 2017, 16:35:01
Subject: Re: [HACKERS] UPDATE of partition key

Next

From: Amit Kapila
Date: 17 May 2017, 16:57:19
Subject: Re: [HACKERS] statement_timeout is not working as expected with postgres_fdw