Using nextval(seq) in more than one column

Поиск
Список
Период
Сортировка
От Sean Davis
Тема Using nextval(seq) in more than one column
Дата
Msg-id 470CC319.7020602@mail.nih.gov
обсуждение исходный текст
Ответы Re: Using nextval(seq) in more than one column  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Using nextval(seq) in more than one column  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: Using nextval(seq) in more than one column  (Nis Jørgensen <nis@superlativ.dk>)
Список pgsql-novice
I am trying to design some tables that have keys that look like:

ASDF-####

where #### should be derived from a sequence.  However, I would like the
primary key to be an integer for speed of indexing, etc.  I don't see a
way using standard DDL followed by inserts to have the #### be the same
number as the integer primary key.  Is that the case?

In other words, I would like the rows to look like:

1   ASDF-1   ....
2   ASDF-2   ....

Thanks,
Sean

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Jim Stalewski"
Дата:
Сообщение: Re: is my pgsql 32 or 64 bit?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Using nextval(seq) in more than one column