[R] Ordered factors and DBMS

Jason Turner jasont at indigoindustrial.co.nz
Thu Oct 4 20:55:13 CEST 2001

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".


Indigo Industrial Controls Ltd.
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

More information about the R-help mailing list