Please keep replies copied to the list so that other people can learn from and comment on the discussion unless to have a good reason to make the thread private. On Mon, Apr 25, 2005 at 21:46:20 +0200, Zlatko Matic <zlatko.matic1@xxxxxxxxxxx> wrote: > The reason for such crazy idea is my front-end MS Access which considers > views as tables and have problem with tables ( views also) if there is no > unique numeric field... > Anyway, how to do it ? > Thanks. I don't know MS Access, so I am not going to be able to help much with this. There may be some way to trick MS Access into thinking that your view has a unique numeric field. It would help to know how it knows that a column has those properties and how it uses the information. > > ----- Original Message ----- > From: "Bruno Wolff III" <bruno@xxxxxxxx> > To: "Zlatko Matic" <zlatko.matic1@xxxxxxxxxxx> > Cc: <pgsql-general@xxxxxxxxxxxxxx> > Sent: Monday, April 25, 2005 6:31 AM > Subject: Re: Calculated bigserial column in a view > > > >On Sun, Apr 24, 2005 at 22:16:14 +0200, > > Zlatko Matic <zlatko.matic1@xxxxxxxxxxx> wrote: > >>I know that it sounds crazy, > >>but I need a bigserial coulumn in a view that is consisted of several > >>tables. > >>That column should not be based on bigserial column of any table, but > >>should be a calculated column... > >>How can I accomplish it ? > > > >This doesn't really make sense. It sounds like you want a key that is > >unique > >accross the union of several tables and that doesn't change when other > >rows > >in the union are added or removed. There are a couple of ways you might > >go about doing something like this. Is this what you really want? > > > >---------------------------(end of broadcast)--------------------------- > >TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
