Re: two slots, for a view-class' slot-definition type

Martin Simmons <[email protected]> Thu, 27 Nov 2003 13:40:53 GMT
Newsgroups gmane.lisp.uncommon-sql
Message-ID <[email protected]>
>>>>> On Wed, 12 Nov 2003 17:59:10 -0800, Sean Champ <[email protected]> said:

  Sean> My first question: Do those two slots need to be seperate and distinct? 

In general the answer is "yes" because there is no precise mapping between SQL
types and CL types.  For example, there is no easy CL way to represent
VARCHAR(n) in CL because the type (STRING n) means strings is exactly length n
rather than at most length n.

I think it might have been an unfortunate design choice for Common SQL to use
the :TYPE slot option to specify the db-type.

-- 
Martin Simmons                            Email: [email protected]
Xanalys Ltd, Compass House, Vision Park   TEL:   +44 1223 257944
Histon, Cambridge CB4 9AD, England.       FAX:   +44 1223 257812