On Wed, May 04, 2005 at 11:47:12 -0400,
Greg Stark <gsstark(at)mit(dot)edu> wrote:
> Bruno Wolff III <bruno(at)wolff(dot)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.
That is more or less what I meant. You can't usefully tie a sequence directly
to a view, the way you can tie one to a table.
In response to
pgsql-interfaces by date
|Next:||From: Frost, Mr. Michael (contractor)||Date: 2005-05-04 17:09:15|
|Subject: Re: PQescapeBytea & PQunescapeBytea |
|Previous:||From: Jeff Eckermann||Date: 2005-05-04 16:01:24|
|Subject: Re: [INTERFACES] calculated identity field in views, again...|
pgsql-general by date
|Next:||From: Bruno Wolff III||Date: 2005-05-04 16:58:47|
|Subject: Re: nonremovable row ?|
|Previous:||From: Fmiser||Date: 2005-05-04 16:35:59|
|Subject: Howto prevent write based on date|