can someone point me at documentation so that i can unserstand the results
of an EXPLAIN, eg:
Index Scan using words_id_idx on books_idx (cost=441.19 rows=7644 width=8)
explain select * from books_idx where wrd_id=1;
I am paticularly interested in what the rows= figure means.
TIA
timj
***
Hi,
I have an existing table and want to change the type of a column from text to oid.
I have tried pg_dumping and psql -e, but get "broken pipe" when inserting the date
into the new table.
pastgresql 6.4 on linux
thanks for your help
timj
[EMAIL PROTECTED]
> MH> Question 2:
> MH> is there a way to get the value of the newly assigned primary key
> MH> after an insert? (rather then following the insert with a select)
>
> MH> e.g. (this would be nice if it worked (networkID is the PKey))
> MH> INSERT into Network (parentID, networkName) values (pid,
