Posted by steve on 08/12/07 06:09

Joe Celko makes the following comment on passing a table as a
parameter
to a procedure:

>> Is it possible to pass a table as a parameter to a function. <<

'Please read a book, any book, on data modeling, and RDBMS. A table
is an entity or a relationship. That would mean you have a magical,
super function that works on Squids, Automobiles, Britney Spears,
Geographical locations or anything in the whole of creation.'

But the super function, reusable functions, is precisely what modern
database developers should have at their disposable! And you can have
it:

http://beyondsql.blogspot.com/2007/08/dataphor-creating-super-function.html

It's also a chance to contrast the idea of a table as a variable,
'any'
table, with the mickey mouse idea of passing a table 'memory' variable
as being implemented in Katami. We are talking apples and oranges
folks :-)

[Back to original message]