Re: Why relational division is so uncommon?



On Apr 26, 3:22 pm, "V.J. Kumar" <vjkm...@xxxxxxxxx> wrote:
Vadim Tropashko <vadimtro_inva...@xxxxxxxxx> wrote innews:1177607284.813162.87940@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

This is an interesting observation as well. Consider a medical
database schema:

PatientSymptom (
name string,
symptom string
)

'Symptom
string' is an ugly hack to emulate relational division for the original
table you've specified below.

I think the misunderstanding here is the "string" which is a datatype.
I should have written "varchar2(100)". Ugly but not ambiguous.

.



Relevant Pages

  • Re: std::string to char*
    ... Is there a reason why not do const_cast? ... because it is an ugly hack? ... where would that leave str? ... target for a string copy operation where the source length exceeds the ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Add methods to string objects.
    ... > You can even get closer, ... bad idea), but given that it does work, why doesn't it work with a string ... Prev by Date: ...
    (comp.lang.python)
  • Re: How to sed a -D with new line ?
    ... I never knew you could cut a string in the middle and have it parse ... I had a really ugly hack to do that: ... Guillaume Dargaud ...
    (comp.unix.shell)
  • Re: Why relational division is so uncommon?
    ... symptom string ... Would db designers pressed hard to avoid set joins and create a ... The db designers won't be hard pressed to avoid set containment joins at ...
    (comp.databases.theory)