PostgreSQL Weekly News

PostgreSQL Weekly News

Posted Apr 28, 2003 16:16 UTC (Mon) by haraldt (guest, #961)
In reply to: PostgreSQL Weekly News by Peter
Parent article: PostgreSQL Weekly News

There isn't much invention. That's exactly the point.

OO isn't more than a shift in terminology. Plus some important implications and some new functions related to that.

OO is moving functionality inside the datasets, so the functions can work with a more limited dataset called "its own".
So, instead of having a function look up and handle the data indexed by a reference number 101, you can ask a function inside a data collection number 101 to handle its own data and spit results back to you.
You can of course add a lot of advanced gingmaloose to that, but it still doesn't stop you from making things simple.

So, I didn't mean more than make something unified out of a join between a data table and a number of view/function/whatever. And define a smart&simple way for the function to reference the data row currently being handled.

If that's in place, you may find a way for a function to store data into the table row being referenced. Or even let a function create a brand new row and put data into it.
And have these functions follow the same rules of inheritance as in the tables. As they do belong with the table definition.

Then, you can begin to worry about isolating/protecting the data entries so functions not defined to belong to that particular table row can't mess with it.

---

(Log in to post comments)