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 1
sequencenumber dpid companyname address
<DpidOwner SequenceNumber="1">
  <DPID>PADPIDA2006111001O</DPID>
  <CompanyName>234AG</CompanyName>
  <Address>Riedtlistrasse 23, ZÃ????????Ã???????Ã??????Ã?????Ã????Ã???Ã??Ã?¼rich, 8006, CH</Address>
 </DpidOwner>
<DPID>PADPIDA2006111001O</DPID> <CompanyName>234AG</CompanyName> <Address>Riedtlistrasse 23, Z�???????�??????�?????�????�???�??�?�¼rich, 8006, CH</Address>
<DpidOwner SequenceNumber="2">
  <DPID>PADPIDA2007011501Q</DPID>
  <CompanyName>OpenIMP</CompanyName>
  <Address>8-10 Rhoda Street, London, E2 7EF, UK</Address>
 </DpidOwner>
<DPID>PADPIDA2007011501Q</DPID> <CompanyName>OpenIMP</CompanyName> <Address>8-10 Rhoda Street, London, E2 7EF, UK</Address>
<DpidOwner SequenceNumber="3">
  <DPID>PADPIDA2007040501K</DPID>
  <CompanyName>The Harry Fox Agency</CompanyName>
  <Address>711 Third Avenue, 8th Floor, New York, 10017, USA</Address>
 </DpidOwner>
<DPID>PADPIDA2007040501K</DPID> <CompanyName>The Harry Fox Agency</CompanyName> <Address>711 Third Avenue, 8th Floor, New York, 10017, USA</Address>
SELECT 3