Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Tue, Dec 12, 2006 at 12:19:56PM -0500, Tom Lane wrote:
>> Usually you do something like
>> select setval('seq_name', (select max(idcol) from table) + 1);
>> after loading data into the table.
> Is "+ 1" necessary with the two-parameter form of setval()?
Given the docs you quoted, no --- I was just too lazy to look up whether
it set is_called or not. With the +1 you don't have to think ;-)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
