From: Greg Stark <gsstark@mit.edu>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Zlatko Matic <zlatko.matic1@sb.t-com.hr>
Cc: Greg Stark <gsstark@mit.edu>
Cc: pgsql-general@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Date: 04 May 2005 11:47:12 -0400
Message-ID: <87vf5zuh6n.fsf@stark.xeocode.com> (raw)
In-Reply-To: <20050504141632.GA8763@wolff.to>
References: <877jifwp6r.fsf@stark.xeocode.com>
<001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
<20050504141632.GA8763@wolff.to>
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
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: gsstark@mit.edu, bruno@wolff.to, zlatko.matic1@sb.t-com.hr, pgsql-general@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
In-Reply-To: <87vf5zuh6n.fsf@stark.xeocode.com>
* 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