Re: Calculated bigserial column in a view

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Calculated bigserial column in a view
Date: 2005-04-25 04:31:10
Message-ID: 20050425043110.GB2882@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Apr 24, 2005 at 22:16:14 +0200,
Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ElayaRaja S 2005-04-25 06:14:22 Help-Urgent
Previous Message Tony Caduto 2005-04-25 04:05:57 question about about future 8.1 and IN, INOUT, and OUT parameters