Re: [INTERFACES] calculated identity field in views, again...

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: [INTERFACES] calculated identity field in views, again...
Дата
Msg-id 87vf5zuh6n.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: [INTERFACES] calculated identity field in views, again...  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: [INTERFACES] calculated identity field in views, again...  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Bruno Wolff III <bruno@wolff.to> writes:

> > How do I create sequence ?
>
> You can't create a sequence for a view. You would need to have it in a
> table that is joined as part of the view.

Sure you can. You can have any expression you want, including nextval('seq')
in your view. The problem is that every time you query it it will provide
different numbers. I can't see that being useful.

--
greg

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgre 8.0 for Linux i586
Следующее
От: Dale Sykora
Дата:
Сообщение: Re: [ADMIN] Postgre 8.0 for Linux i586