| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dale Sykora | 2005-05-04 15:54:53 | Re: [ADMIN] Postgre 8.0 for Linux i586 |
| Previous Message | Scott Marlowe | 2005-05-04 15:38:52 | Re: [GENERAL] Postgre 8.0 for Linux i586 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2005-05-04 16:01:24 | Re: [INTERFACES] calculated identity field in views, again... |
| Previous Message | Scott Marlowe | 2005-05-04 15:38:52 | Re: [GENERAL] Postgre 8.0 for Linux i586 |