From: Bruno Wolff III <bruno@wolff.to>
To: Greg Stark <gsstark@mit.edu>
Cc: Zlatko Matic <zlatko.matic1@sb.t-com.hr>
Cc: pgsql-general@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Date: Wed, 4 May 2005 11:46:29 -0500
Message-ID: <20050504164629.GA30968@wolff.to> (raw)
In-Reply-To: <87vf5zuh6n.fsf@stark.xeocode.com>
References: <877jifwp6r.fsf@stark.xeocode.com>
<001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
<20050504141632.GA8763@wolff.to>
<87vf5zuh6n.fsf@stark.xeocode.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bruno@wolff.to, gsstark@mit.edu, zlatko.matic1@sb.t-com.hr, pgsql-general@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
In-Reply-To: <20050504164629.GA30968@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox