[Babase] sexid NULL problem

Karl O. Pinc kop at meme.com
Mon May 12 16:40:10 EDT 2008


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.

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.

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