On Tue, 22 Feb 2000, Marco Giardini wrote:
> how do i set a table with an autonumebr field? I mean a field that it's
> automatically increased by one for each added record.
Use a SERIAL column.
E.g.:
create table x (a text, b serial);
insert into x(a) values ('abc');
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden