Re: [GENERAL] The use of sequences

1998-08-18 Thread Jeremiah Davis
CREATE SEQUENCE some_sequence start 1 increment 1; CREATE TABLE person ( id int4 default nextval('some_sequence'), name varchar(200), description text); INSERT INTO person VALUES(nextval('some_sequence'),'Jeremiah','not much'); or INSERT INTO person(name,description) VALUES('Jeremiah','not muc

Re: [GENERAL] Select MIN() & MAX()

1998-08-12 Thread Jeremiah Davis
I'm using this in a an application right now: $result = pg_Exec($conn, "SELECT MAX(pos) FROM demogallery;"); and its been working fine for about 2-3 months... On Wed, 12 Aug 1998, Krasnow, Greg wrote: > In the documentation it mentions that Postgresql does not currently support > MIN() and M