Re: General Questions about PG

Relaxin wrote:

> Can someone help with this...please?
>
> "Relaxin" <me@yourhouse.com> wrote in message
> news:ejraqt$2m5u$1@news.hub.org...
>> (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