>  I have a table and want to make a view updateable with rules. Table has a
>  sequence that creates default value to primary key when inserting.
>
>  And now the question: Is it posible to return value of primary key from
>  rule of inserting with NEW? Is that value what i would get from extern
>  calling to insert, instead of OID?.

SELECT currval('seq-table-name_seq-field-name_seq');

where seq-table-name is the name of your table (not the view), and
seq-field-name is the name of the primary key.

Greg


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to