Hi,
Sometimes I want to restrict the structure of my data. Let's say that I need to some records does not contain NULL values, or some numbers are not longer then 10 digits. But when I try to use login char(32) NOT NULL default 'tralala', or id bigint NOT NULL default 50000000, and then try to insert some data into the table with some definitions like above with some NULL 'login' values or with too long 'id' integer I have no problems with inserting it. In this two cases I will insert it anyway. But in postgresql databases with similar table definitions I will not be able to insert such a data. Is there a way to restrict it hurder, that when I say that in this column in this table there can not be any NULL values? And I will not be able to insert any data into the table with NULL values? Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]