Re: [INTERFACES] calculated identity field in views, again... - Mailing list pgsql-general

From Greg Stark
Subject Re: [INTERFACES] calculated identity field in views, again...
Date
Msg-id 87vf5zuh6n.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [INTERFACES] calculated identity field in views, again...  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: [INTERFACES] calculated identity field in views, again...
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgre 8.0 for Linux i586
Next
From: Dale Sykora
Date:
Subject: Re: [ADMIN] Postgre 8.0 for Linux i586