| From: | Christophe Labouisse <christophe(dot)labouisse(at)dial(dot)oleane(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] Unique Number KEY |
| Date: | 1999-02-26 22:45:00 |
| Message-ID: | m3yalk3hub.fsf@gabuzo.meunet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
CIMPOESU Teodor <teo(at)digiro(dot)net> writes:
> you have 2 ways to do it:
> 1. try something like
> CREATE TABLE STUDENTS(
> studentID int4 DEFAULT 'int(now())',
> studentName text );
Is suspect int(now()) to have a resolution of one second. Therefore
this will not work if you insert more than one record in a second.
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 167 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sue Hanen | 1999-02-27 03:02:44 | Trying to concatenate using a string variable and text |
| Previous Message | David Martinez Cuevas | 1999-02-26 20:51:56 | Re: [SQL] CREATE TABLE |