Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] calculated identity field in views, again...

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>,Greg Stark <gsstark(at)mit(dot)edu>, pgsql-general(at)postgresql(dot)org,pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Date: 2005-05-04 15:47:12
Message-ID: 87vf5zuh6n.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
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.

-- 
greg


In response to

Responses

pgsql-interfaces by date

Next:From: Jeff EckermannDate: 2005-05-04 16:01:24
Subject: Re: [INTERFACES] calculated identity field in views, again...
Previous:From: Scott MarloweDate: 2005-05-04 15:38:52
Subject: Re: [GENERAL] Postgre 8.0 for Linux i586

pgsql-general by date

Next:From: Dale SykoraDate: 2005-05-04 15:54:53
Subject: Re: [ADMIN] Postgre 8.0 for Linux i586
Previous:From: Scott MarloweDate: 2005-05-04 15:38:52
Subject: Re: [GENERAL] Postgre 8.0 for Linux i586

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group