[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