[Babase] MPI actor_actee view names

Lacey Maryott lacey.maryott at duke.edu
Tue Nov 20 15:22:54 EST 2007


Karl

     I don't see this as a problem, I think it'll be ok just to quantify 
table names when querying multiple tables! :)

Lacey

Karl O. Pinc wrote:
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu 



More information about the Babase mailing list