[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