Date: Wed, 4 May 2005 11:46:29 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Greg Stark <gsstark@mit.edu>
Cc: Zlatko Matic <zlatko.matic1@sb.t-com.hr>,
	pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Message-ID: <20050504164629.GA30968@wolff.to>
Mail-Followup-To: Bruno Wolff III <bruno@wolff.to>,
	Greg Stark <gsstark@mit.edu>,
	Zlatko Matic <zlatko.matic1@sb.t-com.hr>,
	pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org
References: <877jifwp6r.fsf@stark.xeocode.com>
	<001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
	<20050504141632.GA8763@wolff.to> <87vf5zuh6n.fsf@stark.xeocode.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <87vf5zuh6n.fsf@stark.xeocode.com>
User-Agent: Mutt/1.5.6i

On Wed, May 04, 2005 at 11:47:12 -0400,
  Greg Stark <gsstark@mit.edu> wrote:
> 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.

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.