Posted by steve on 09/20/07 09:32

When tables are 'variables' you can create what I called
a 'Super Function'. Pass any table of the appropriate 'type'
to the function, it's that simple. The example was a function
that returned a dense rank including when the target column
of the rank repeats. The function assumed a single primary key.
And only the PK and the target column of the rank constituted
the table to be passed to the function.
http://beyondsql.blogspot.com/2007/08/dataphor-creating-super-function.html

Well it's a simple matter to overload the function for tables that
have a compound primary key. And you can envision a library of
different functions based on table 'type'.
http://beyondsql.blogspot.com/2007/09/dataphor-super-function-ii.html

Hopefully some will 'get' it :-)

www.beyondsql.blogspot.com

[Back to original message]