On Wed, Oct 22, 2008 at 5:00 PM, Joseph Scott <[EMAIL PROTECTED]>wrote:
> It's just done differently. Instead of making the auto number feature a > column attribute, it's done as a separate object (called a sequence). > <snip> > > In PostgreSQL (and any other DB that uses sequences, like Oracle) the order > would be switched: > > - Ask for a new auto number ID from the sequence > - Insert the new data, using the ID we got from the sequence > > That said it's pretty common in PostgreSQL to make an auto number field > who's default value is to select the next number from the sequence. > Alternatively, you can define your PostgreSQL tables with columns of type "serial", which just creates a sequence, and makes that column's default value be the next value in the created sequence. Then you can do your INSERT statements use the RETURNING keyword[1] and -- assuming the PHP driver knows how to deal with that -- grab the output normally. INSERT INTO mytable (id, foo, bar, ham spam) VALUES (DEFAULT, 'blah', 'bleh', 'pizza', 'pizza') RETURNING id; Roberto -- http://blog.divisiblebyfour.org/ _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
