RE: [SQL] Re: OID Perfomance - Object-Relational databases

2000-10-04 Thread Michael Ansley
Title: RE: [SQL] Re: OID Perfomance - Object-Relational databases Given what we've been discussing over the past day or so, can anybody explain this to me: dev=# explain select client.address.postcode from client; NOTICE:  QUERY PLAN: Seq Scan on client  (cost=0.00..1.01 rows=1 wi

[SQL] Re: OID Perfomance - Object-Relational databases

2000-10-04 Thread Jeff MacDonald
Hi Josh, I didn't get right tho this, because well.. you asked the list, i figured i'd give them a chance first. and they've answered the same as i would have.. > Because it's a very elegant solution to my database structure issues, > I'm using OID's extensively as referents and foriegn ke