[Ur] Joining Nullable to Non-nullable fields

Simon Van Casteren simon.van.casteren at gmail.com
Fri Jun 7 01:58:18 EDT 2019


This works, absolutely awesome! Thanks!

Op do 6 jun. 2019 om 14:46 schreef Athene Noctua <steenuil.owl at gmail.com>:

> I had an issue with outer joins a while ago, it's not exactly what you
> describe but maybe the answer could help:
>
> http://www.impredicative.com/pipermail/ur/2017-July/002645.html
>
> Cheers
>
> On Thu, Jun 6, 2019, 13:56 Simon Van Casteren <
> simon.van.casteren at gmail.com> wrote:
>
>> Hey everybody,
>>
>> Something that's been bothering me for some time now. Is it possible to
>> OUTER JOIN a nullable field to a non-nullable field? I keep getting type
>> errors and can't figure out how to tell the compiler he should only do the
>> join for the records that the nullable field is non-null... SQL surely
>> allows this, but I haven't figured it out in Ur/Web yet.
>>
>> Any help much appreciated!
>>
>> Keep up the good work.
>>
>> Simon
>> _______________________________________________
>> Ur mailing list
>> Ur at impredicative.com
>> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
>>
> _______________________________________________
> Ur mailing list
> Ur at impredicative.com
> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.impredicative.com/pipermail/ur/attachments/20190607/201cd668/attachment.html>


More information about the Ur mailing list