Hi all, How does one find the next value of a serial item? Given a simple table with a serial primary key, I'd like to get the next available integer key value. eg:
CREATE TABLE foo ( foo_id SERIAL PRIMARY KEY, name text DEFAULT NULL); SELECT foo_id, name FROM foo; > 1|red 2|green 3|blue SELECT ???; > 4 Thanks! Scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users