Re: Calculated bigserial column in a view - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Calculated bigserial column in a view
Date
Msg-id 20050425043110.GB2882@wolff.to
Whole thread Raw
In response to Calculated bigserial column in a view  ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
On Sun, Apr 24, 2005 at 22:16:14 +0200,
  Zlatko Matic <zlatko.matic1@sb.t-com.hr> 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?

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Immutable attributes?
Next
From: Tony Caduto
Date:
Subject: question about about future 8.1 and IN, INOUT, and OUT parameters