[GENERAL] Adding auto-increment / sequence

Hey all, Is there any way to add some kind of sequence of auto-incrementing column to the result set returned by a SELECT? I need to get an auto incrementing column of some kind into the result set from a view? Thanks in advance, Cam ---(end of broadcast)---

[GENERAL] Are foreign key's automatically set as indicies?

Hey all, I'm sorta new to PG and am just wondering, when I create a foreign key is it automatically set as an indexed column or do I need to also set that manually? Thanks in advance, Cam ---(end of broadcast)--- TIP 4: Have you searched our list a