![]() | |
#51
| |||
| |||
|
|
On Jul 25, 2:58 pm, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: For instance if we have relation: R := {w, x, y} where the tuples are: w := (a:1, b:1) x := (a:2, b:2) y := (a:3, b:2) then "ordering by a" yields a total ordering over R: {(w, x), (w,y), (x,y)} but "ordering by b" gives the partial ordering: {(w, x), (w,y)} OK. But who the recepient of the ORDER BY output? I assume it is some sort of SQL client. Can it understand partial order? |
#52
| |||
| |||
|
|
On Jul 25, 2:58 pm, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: For instance if we have relation: R := {w, x, y} where the tuples are: w := (a:1, b:1) x := (a:2, b:2) y := (a:3, b:2) then "ordering by a" yields a total ordering over R: {(w, x), (w,y), (x,y)} but "ordering by b" gives the partial ordering: {(w, x), (w,y)} OK. But who the recepient of the ORDER BY output? I assume it is some sort of SQL client. Can it understand partial order? |
#53
| |||
| |||
|
|
On Jul 25, 2:58 pm, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: For instance if we have relation: R := {w, x, y} where the tuples are: w := (a:1, b:1) x := (a:2, b:2) y := (a:3, b:2) then "ordering by a" yields a total ordering over R: {(w, x), (w,y), (x,y)} but "ordering by b" gives the partial ordering: {(w, x), (w,y)} OK. But who the recepient of the ORDER BY output? I assume it is some sort of SQL client. Can it understand partial order? |
#54
| |||
| |||
|
|
On Jul 25, 2:58 pm, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: For instance if we have relation: R := {w, x, y} where the tuples are: w := (a:1, b:1) x := (a:2, b:2) y := (a:3, b:2) then "ordering by a" yields a total ordering over R: {(w, x), (w,y), (x,y)} but "ordering by b" gives the partial ordering: {(w, x), (w,y)} OK. But who the recepient of the ORDER BY output? I assume it is some sort of SQL client. Can it understand partial order? |
#55
| |||
| |||
|
|
On Jul 25, 2:58 pm, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: For instance if we have relation: R := {w, x, y} where the tuples are: w := (a:1, b:1) x := (a:2, b:2) y := (a:3, b:2) then "ordering by a" yields a total ordering over R: {(w, x), (w,y), (x,y)} but "ordering by b" gives the partial ordering: {(w, x), (w,y)} OK. But who the recepient of the ORDER BY output? I assume it is some sort of SQL client. Can it understand partial order? |
![]() |
| Thread Tools | |
| Display Modes | |
| |