Umm... geometries I use with Postgis & Spatialite - I don't have a database without them. Can anyone come up with a data domain for which location has no relevance? I used to think I had some (like taxonomies & dictionaries), but I've been corrected in each case :-)
also IP addresses Brent Wood From: James K. Lowden <jklow...@schemamania.org> To: sqlite-users@mailinglists.sqlite.org Sent: Thursday, May 23, 2019 10:56 AM Subject: Re: [sqlite] SQL Features That SQLite Does Not Implement On Wed, 22 May 2019 14:20:11 -0600 "Keith Medcalf" <kmedc...@dessus.com> wrote: > (such as was added to DB2 back in the late 80's early 90's, and > which I do not think anyone else has implemented as nicely anywhere > else) That's an interesting aside. It would make an interesting OT thread, if you're inclined to start it. ;-) I've always thought user-defined types were unnecessary except as a convenience. There are few new primitive types; most user-defined types I can think of are "structures" -- sets of columns -- that one might like to name and constrain as a new type that may appear in many tables. About the only primitive type I can imagine are mathematical: complex numbers or exact numeric representations. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users