Re: General Questions about PG

Relaxin wrote:

> Can someone help with this...please?
>
> "Relaxin" <me(at)yourhouse(dot)com> wrote in message
> news:ejraqt$2m5u$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
>> (NOTE: This is for the Windows version of PG)
>>
>> I'm looking for a replacement for SQLBase, and I have a few questions
>> about PG.
>>
>>
>> 1. Is PostgreSQL OS multi-threaded?
>> 2. Does PG support bi-directional resultsets. (i.e. If I'm record 4,
>>
>> can I do "Prior" to re-access record 3?)
>>
>> 3. Does PG have the concept of a Record Indentifier (ROWID) by which
>> can be used to update or delete a record?
>> (i.e.
>> 1. SELECT first_name, ROWID from customer.
>> 2. <Results are>
>> Paul, 0x123456780
>> Mike, 0x123456781
>> John, 0x123456782
>> 3. DELETE FROM customer WHERE rowid = 0x123456781;
>> //Delete 'MIKE' from the table
>>
>>
>> Thank you...
>>
>>
1. No, it uses processes.

http://www.postgresql.org/files/documentation/books/
aw_pgsql/hw_performance/node12.html

3. You can create a column of type serial.

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL

--
John Koller