[Babase] sexid NULL problem
kfenn
kfenn at princeton.edu
Tue May 13 08:22:44 EDT 2008
Karl O. Pinc wrote:
>
> On 05/12/2008 02:37:08 PM, kfenn wrote:
>> HI Karl,
>>
>> One more nagging thing I meant to mention on the phone.
>>
>> The documentation on sexskins says:
>>
>>
>> Column Descriptions
>>
>>
>> Sxid (Sexskins IDentifier)
>>
>> A unique integer which identifies the SEXSKINS row.
>>
>> This column is automatically maintained by the database, cannot be
>> changed, and must not be NULL.
>>
>>
>> However in cycles_sexskin, the first female, ABB, has nothing but
>> nulls for her series 1 cycle sexid.
>
> This is the difference between cycles_sexskins and sexskins_cycles.
> Cycles_sexskins returns at least one row for every CYCLES row, whereas
> sexskins_cycles only returns rows where there are SEXSKINS rows.
>
OK, that makes sense. I did check the sexskins table and there were no
NULLs for sxid there so I was guessing it had something to do with using
a view, but I wanted to check.
> The first does an outer join, the second does not. There are
> a number of views that are "paired" this way.
>
> You probably want sexskins_cycles for most purposes, including
> uploading data. You'll want to read the descriptions of the
> views and see what I said there, if any special tricks occurred to
> me.
>
OK again. I was only using the cycles_sexskin view because the sexskin
documentation says so:
Tip
Use the CYCLES_SEXSKINS
<https://papio.biology.duke.edu/babase_system_html/ch07s15.html> view to
maintain this table.
Should the documentation be changed?
Tabby
> 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
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list