On Wed, 22 May 2019 17:56:23 -0700 Jens Alfke <j...@mooseyard.com> wrote:
> > On May 22, 2019, at 3:55 PM, James K. Lowden > > <jklow...@schemamania.org> wrote: > > > > I've always thought user-defined types were unnecessary except as a > > convenience. > > User-defined types are quite important if you?re doing fancy stuff in > user-defined functions, where data that?s stored in tables as blobs > has an internal structure visible to those functions. (JSON is a good > example, and the reason why SQLite added its ?subtypes? feature.) I see. So user-defined type here isn't some combination of extant primitive types, but a blob that *could* be represented by extant types but is instead represented another way. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
