MIME-Version: 1.0
Message-ID: 
 <trinity-6e09d2e7-5b50-4002-89a6-b6b57f270e35-1605036221003@3c-app-gmx-bs26>
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
Cc: psycopg@lists.postgresql.org
Subject: Aw: Re: psycopg3 and adaptation choices
Content-Type: text/plain; charset=UTF-8
Date: Tue, 10 Nov 2020 20:23:41 +0100
Importance: normal
Sensitivity: Normal
In-Reply-To: 
 <CAMqTPq=xmi67QHdhbaOh_EWsDWAR7rMf4MFGB9avsEP=dYzVXg@mail.gmail.com>
References: 
 <CA+mi_8Zdk_beGcbOjkpdo+fchTR5ot1XM2zZc=ujSGqP+WVh-g@mail.gmail.com>
 <2b9859f0-0964-2baa-b6bc-13f975ae0f67@aklaver.com>
 <CA+mi_8ZfV+rEDKaqM-pcSf43FuN4FUJGoGTxvEEXap-x_GWP0Q@mail.gmail.com>
 <88fb7a7e-a182-a816-c1a7-8a1f54b65215@aklaver.com>
 <CA+mi_8YUEPfTPqD-1Jxm6NUwgJpWxPgejRZ+2-mPQr=0DQWiHA@mail.gmail.com>
 <4830fb8d-fa57-e0f8-0e4f-a96ed040dede@dndg.it>
 <CA+mi_8a+Q0C2LwiedwNkRPVY=-G3q0zW6w19zYvvADtdEd4b_w@mail.gmail.com>
 <1546497c-ff41-9bd0-b4d7-931bd305caac@dndg.it>
 <CAMqTPqkac5xa=+kwKLj8DEr9OdrkJpEzJj4Re8VvKP=JeTdZog@mail.gmail.com>
 <CA+mi_8aRQBG+Lz12oW0Be62RSR7UEEoev5Yn34ZSygcOgxbOCw@mail.gmail.com>
 <9989BCEF-2CC4-4AA4-9E4E-C83740F21414@thebuild.com>
 <CA+mi_8aWb9avqTtm=MZcNzUVvKvvWYS7BzcuCapgA9wnNFRyGQ@mail.gmail.com>
 <CAMqTPq=xmi67QHdhbaOh_EWsDWAR7rMf4MFGB9avsEP=dYzVXg@mail.gmail.com>
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

> My particular=C2=A0question is regarding '-2' score for mapping numbers
> to 'unknown'=2E
> =C2=A0
> Why do you consider it such an important use-case? In my opinion,
> such usage is just waste of resources and traffic,

I am sometimes round-tripping magic constants to tell which part of a, say=
,
UNION actually returned the result(s), based on which knowledge the EMR
UI will behave slightly differently (say, one is retrieving medications,
by matching either of product name or active ingredient, all in
one query)=2E

I needn't roundtrip ints, sure, but=2E=2E=2E

Karsten