Re: lisp mail archive software

On Monday, July 7, 2003, at 12:35 AM, John DeSoi wrote:
>
> On Sunday, Jul 6, 2003, at 15:08 US/Eastern, Miles Egan wrote:
>>
>> Good to know.  I definitely like the approach.  Do you know offhand if
>> it supports autoincrement fields the way the native client libs do?  I
>> think the native libs let you execute a special select after 
>> inserting a
>> new row with an autoincrement key.  The client libs supposedly retain
>> this as a per-thread value.
>
> Yes, Postgresql supports this:
>
> SELECT currval('name_of_sequence')
>
> Best,
>
> John DeSoi, Ph.D.
>

What Miles means, I think, is:

insert into customers (id, name) values (nextval('name_of_sequence'), 
'Foobar');

If this is what he means, I don't see anything special about it, it 
would work with any SQL interface, and certainly with pg.lisp

Sven