[R] Ordered factors and DBMS

[Jason Turner]

Additions to Doug Bates' suggestions

> ... it could be expressed naturally as two tables and a
> join.  The first table would contain the data as factor levels and the
> second table would give the correspondence between levels and labels.

I think this is probably the most clear and elegant way to do it.
 
> Another possibility is to define a PostgreSQL data type for this.

See the PosgreSQL documentation for "CREATE TYPE".

Cheers

Jason
-- 
Indigo Industrial Controls Ltd.
64-21-343-545
jasont at indigoindustrial.co.nz
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._