Martin Knipper <[EMAIL PROTECTED]> writes:
> I thought about a mixture of object orientation and a normal table
> for a relational database.
> someFunction() is a method for the object/table someTable.
Perhaps you could do what you want with functions accepting table
rowtypes.
create function someFunction(someTable) returns ...
select someFunction(t.*) from someTable t where ...
-- works
select someFunction(t.*) from anotherTable t where ...
-- fails
create function someFunction(anotherTable) returns ...
select someFunction(t.*) from someTable t where ...
-- still works
select someFunction(t.*) from anotherTable t where ...
-- now calls the second someFunction()
As of existing releases this doesn't scale well to large tables, because
passing a whole table row to a function leaks memory intraquery. That
is fixed for 7.5 though.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
