[ZDP] BackTalk to Document The Zope Book (2.5 Edition)/Relational Database Connectivity

webmaster@zope.org webmaster@zope.org
Sat, 28 Sep 2002 05:43:59 -0400

A comment to the paragraph below was recently added via http://www.zope.org/Documentation/Books/ZopeBook/current/RelationalDatabases.stx#2-18


    This SQL will create a new table in your Gadfly database called
    *employees*.  This table will have four columns, *emp_id*, *first*,
    *last* and *salary*.  The first column is the employee id, which is a
    unique number that identifies the employee.  The next two columns have
    the type *varchar* which is similar to a string.  The *salary* column
    has the type *float* which holds a floating point number.  Every
    database supports different kinds of types, so consult your
    documentation to find out what kind of types your database supports.

      % Anonymous User - Sep. 28, 2002 5:43 am:
       /employee id, which is a unique number/
       is that correct or is the wish the father of the thought?
       i dont see any uniquness constraints and, AFAIK, gadfly hasnt any.