Is it true that PostgreSQL sequences are always INT4? If so, how
would the following be modified to work as obviously intended?
CREATE SEQUENCE tbl_id INCREMENT 1 START 1;
CREATE TABLE tbl
(
id INT8 DEFAULT NEXTVAL('tbl_id') PRIMARY KEY
);
Thanks.
Lyle Frost
Citadel Networ
"Haywood J'Bleauxmie" wrote:
>I have a database that tracks work orders. Each order tracks two entries
>from the employees table; the employee ID of the person assigned to the
>work order and the ID of the person who completed the order. Each work
>order may have one, both, or neither f
I have a database that tracks work orders. Each order tracks two entries
from the employees table; the employee ID of the person assigned to the
work order and the ID of the person who completed the order. Each work
order may have one, both, or neither field filled in. As such, I need to
left
