John Elrick wrote:
John Stanton wrote:

John Elrick wrote:


SNIP

Introspection would occur via this mechanism and would even move all introspection for any given system behind a common interface.

Just a thought.


John Elrick

CREATE TABLE already stores the type as its declared type. The user has that available to enforce type restrictions or to direct type conversions.


My apologies, I meant "any type" as in types which are not defined by Sqlite, such as DATE, TIMESTAMP, ADDRESS, LEFT_HANDED_SPANNER, or DEAD_PARROT.
John

Sqlite lets you put in anything as the declared type. "DEAD PARROT", "MONGOOSE", "GODZILLA" or "DECIMAL(6,1)" are all acceptable declared types. Sqlite makes the underlying type TEXT if it is not obviously numeric.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to