Re: auto increment

On Jue 09 Nov 2000 07:56, Marcos wrote:
> hi,
>
>     i am creating a table and i want to add an auto incrementable field
>
>     is that correct?
>
> psql ival << EOF
> create table partes (
> codigo int not null auto_increment,

WRONG. That is not ANSI-SQL. That is MySQL.
Define it as SERIAL, just like all the good database servers do.

> usuario varchar(15),
> fecha date,
> proyecto varchar(30),
> horas int4,
> trabajo varchar(100),
> observaciones varchar(90),
> primary key(codigo));
> EOF

Try to read the user manual for information on querys.

Saludos... :-)


--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart�n Marqu�s            email:     martin@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------