Create Table Unique problem... bug? - Mailing list pgsql-novice

Hi, I've a problem creating a table. My Sql
instruction is:

CREATE TABLE questiontypes (
  id integer NOT NULL,
  flags integer,
  label text,
  UNIQUE (id,flags)
);

Is it ok?? I must have 'flags' like to NULL... but
'id' is NOT NULL...
Now if I insert a row:

INSERT INTO questiontypes (id,flags,label) values
(2,null,'a');

and re-insert it... I can!!!! Now there are two
identical row, and UNIQUE??
I think postgres must occur an error? Is it Ok?

(The same problem is with:
INSERT INTO questiontypes (id,label) values (2,'a');
Is it ok?)

Thanks you, Mauro


______________________________________________________________________
Yahoo! Mail: 6MB di spazio gratuito, 30MB per i tuoi allegati, l'antivirus, il filtro Anti-spam
http://it.yahoo.com/mail_it/foot/?http://it.mail.yahoo.com/