[Babase] MPI actor_actee view names
Karl O. Pinc
kop at meme.com
Tue Nov 20 12:00:32 EST 2007
It occurs to me that the column names in the MPI_EVENTS
view share some names with the ACTOR_ACTEES view.
I.e. both have columns named Actor and Actee.
I don't see this as a problem, it will only ever come
up if both MPI_EVENTS and ACTOR_ACTEES are used in the
same SQL statement, but in the past there's been some
aversion to having "duplicate" column names so I thought
I'd bring it up for discussion.
Note that we already have lots of "duplicate" column names,
notably Date columns. If it ever does cause a problem the
solution is to use the AS keyword and "rename" the column
within the query.
I hope to have full documentation done later today
for all the MPI stuff. We'll
see...
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list