On Wed, May 04, 2005 at 11:47:12 -0400,
Greg Stark <gsstark@xxxxxxx> wrote:
> Bruno Wolff III <bruno@xxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
