Re: [boost] [review] [sqlite]

n Mon, Nov 18, 2024 at 1:09 PM Klemens Morgenstern wrote:

On Mon, Nov 18, 2024 at 6:10 PM Dominique Devienne wrote:

...

On Mon, Nov 18, 2024 at 10:34 AM Klemens Morgenstern via Boost wrote:

...

On Mon, Nov 18, 2024 at 1:03 AM Barend Gehrels via Boost wrote:

...

One of its columns is typed geometry This is probably a subtype, which would make a great example for custom conversions. Are you using spatialite? The notion of subtype [4] exist in SQLite, but is very *transient*.

It would be good to have an example explaining what you just said, because I certainly fell for the subtype gotchas in the past.

https://sqlite.org/forum/forum?s=subtype in general, and https://sqlite.org/forum/forumpost/340b2fde7a30de50bf3189d6813289f80e6462132... in particular for the fact subtypes from views are lost. --DD