[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