Re: UNIQUE constraint, proper use

> I have this SQL statement: > > CREATE TABLE rooms ( > idSERIAL, > room_name TEXT UNIQUE, > location TEXT, > last_updated TIMESTAMP DEFAULT > CURRENT_TIMESTAMP NOT NULL

Re: UNIQUE constraint, proper use

In article <[EMAIL PROTECTED]>, Ferindo Middleton Jr <[EMAIL PROTECTED]> writes: > I have this SQL statement: > CREATE TABLE rooms ( > idSERIAL, > room_name TEXT UNIQUE, > location TEXT, >

Re: UNIQUE constraint, proper use

At 22:49 -0500 11/21/05, Ferindo Middleton Jr wrote: I have this SQL statement: CREATE TABLE rooms ( idSERIAL, room_name TEXT UNIQUE, location TEXT, last_updated TIMESTAMP

UNIQUE constraint, proper use

I have this SQL statement: CREATE TABLE rooms ( idSERIAL, room_name TEXT UNIQUE, location TEXT, last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,