Am Dienstag, 21. Juni 2005 12:01 schrieben Sie:
> hi,in a table with a serial datatype, how do i get the sequence to start at
> a specific number like 10?
Use START in the create sequence statement.
#
create sequence seq_xeingang increment 1 start 1000;
;
CREATE TABLE xeingang
(
id
On Jun 21, 2005, at 7:01 PM, Kenneth Gonsalves wrote:
in a table with a serial datatype, how do i get the sequence to start
at a specific number like 10?
The SERIAL datatype (e.g., CREATE TABLE foo(foo_id SERIAL) )is a
shorthand for something like
CREATE SEQUENCE foo_id_seq;
CREATE TAB
hi,
in a table with a serial datatype, how do i get the sequence to start
at a specific number like 10?
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
---(end of broadcast)---
TIP 7: don't
On Tuesday 21 June 2005 13:01, you wrote:
> hi,
> in a table with a serial datatype, how do i get the sequence to start
> at a specific number like 10?
ALTER SEQUENCE sequence_name RESTART WITH 10;
--
Krasimir Dimitrov
IT Departme
