Zlatko Matic wrote:
> I need to have an "identity" column in a view.
> I was using bigserial columns in tables and Postgre created nextval
> function expression automatically.
> Now I have tried with nextval function in the view, but with no success....
> How can I put a bigserial column in a view ?
What do you mean by an "identity" column in a view? A view is just a
named query, so doesn't hold any data of its own. Can you explain what
you are trying to achieve?
--
Richard Huxton
Archonet Ltd