Re: Re: proposal: ignore null fields in not relation type composite type based constructors - Mailing list pgsql-hackers

From Jeevan Chalke
Subject Re: Re: proposal: ignore null fields in not relation type composite type based constructors
Date
Msg-id CAM2+6=UJDZDE+hcWO0sbh_DrdqiVuFrXs24HZ5CAXK396jshwg@mail.gmail.com
Whole thread Raw
In response to Re: proposal: ignore null fields in not relation type composite type based constructors  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Re: proposal: ignore null fields in not relation type composite type based constructors
List pgsql-hackers
<div dir="ltr">Hi Pavel,<br /><br />You have said that XMLFOREST has something which ignores nulls, what's that?<br
/>Willyou please provide an example ?<br /><br />I am NOT sure, but here you are trying to omit entire field from the
output<br/> when its value is NULL. But that will add an extra efforts at other end<br />which is using output of this.
Thatapplication need to know all fields and<br />then need to replace NULL values for missing fields. However we have
an<br/> optional argument for ignoring nulls and thus we are safe. Application will<br />use as per its choice.<br
/><br/>Well, apart from that, tried reviewing the patch. Patch was applied but make<br />failed with following
error.<br/><br />make[3]: Entering directory `/home/jeevan/pg_master/src/backend/catalog'<br />cd
../../../src/include/catalog&& '/usr/bin/perl' ./duplicate_oids<br />3255<br />make[3]: *** [postgres.bki]
Error1<br /><br /> Please run unused_oids script to find unused oid.<br /><br />However, I had a quick look over code
changes.At first glance it looks<br />good. But still need to check on SQL level and then code walk-through.<br /><br
/>Waitingfor updated patch.<br /><br />Thanks<br /><br /><div class="gmail_extra">-- <br /><div dir="ltr">Jeevan B
Chalke<br/>Principal Software Engineer, Product Development<br />EnterpriseDB Corporation<br />The Enterprise
PostgreSQLCompany<br /><br /></div></div></div> 

pgsql-hackers by date:

Previous
From: Rajeev rastogi
Date:
Subject: Re: Support for N synchronous standby servers
Next
From: Heikki Linnakangas
Date:
Subject: Re: option -T in pg_basebackup doesn't work on windows