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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
