add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE

INSERT 0 4
query_to_xml
<table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<row>
  <Id>1</Id>
  <FirstName>François</FirstName>
  <LastName>Tremblay</LastName>
  <City>Montreal</City>
  <State>QC</State>
</row>

<row>
  <Id>2</Id>
  <FirstName>Bjørn</FirstName>
  <LastName>Hansen</LastName>
  <City>Oslo</City>
  <State xsi:nil="true"/>
</row>

</table>
 
SELECT 1