X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4190E53620;
	Wed,  4 May 2005 12:47:35 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 25524-01; Wed,  4 May 2005 15:47:32 +0000 (GMT)
Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227])
	by svr1.postgresql.org (Postfix) with ESMTP id B3105534AD;
	Wed,  4 May 2005 12:47:31 -0300 (ADT)
Received: from localhost ([127.0.0.1] helo=stark.xeocode.com)
	by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian))
	id 1DTM5h-0007HF-00; Wed, 04 May 2005 11:47:13 -0400
To: Bruno Wolff III <bruno@wolff.to>
Cc: Zlatko Matic <zlatko.matic1@sb.t-com.hr>,
	Greg Stark <gsstark@mit.edu>, pgsql-general@postgresql.org,
	pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
References: <877jifwp6r.fsf@stark.xeocode.com>
	<001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
	<20050504141632.GA8763@wolff.to>
In-Reply-To: <20050504141632.GA8763@wolff.to>
From: Greg Stark <gsstark@mit.edu>
Organization: The Emacs Conspiracy; member since 1992
Date: 04 May 2005 11:47:12 -0400
Message-ID: <87vf5zuh6n.fsf@stark.xeocode.com>
Lines: 13
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200505/189
X-Sequence-Number: 77537

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