Re: FAQ error

> Bruce Momjian writes:
>
> > Our FAQ, item 4.16.2 has:
> >
> > $newSerialID = nextval('person_id_seq');
> > INSERT INTO person (id, name) VALUES ($newSerialID, 'Blaise Pascal');
> >
> > Is this correct Perl?
>
> No. I always thought it was pseudo code. I think it's fine.

It is psaudo-code, but the assignment for nextval() is just wrong:

> > $newSerialID = nextval('person_id_seq');

I am going to flesh this out with the SELECT but not the rest.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026