Github user fmcquillan99 commented on the issue:
https://github.com/apache/madlib/pull/234
Similarly
```
DROP TABLE IF EXISTS abalone_out, abalone_out_dictionary;
SELECT madlib.encode_categorical_variables (
'abalone', -- Source table
'abalone_out', -- Output table
'height::TEXT' -- Categorical columns
);
SELECT * FROM abalone_out ORDER BY id;
```
produces
```
-[ RECORD 1 ]------+------
id | 1
sex | M
length | 0.455
diameter | 0.365
height | 0.095
rings | 15
height::TEXT_0.08 | 0
height::TEXT_0.085 | 0
height::TEXT_0.09 | 0
height::TEXT_0.095 | 1
height::TEXT_0.1 | 0
height::TEXT_0.11 | 0
height::TEXT_0.125 | 0
height::TEXT_0.13 | 0
height::TEXT_0.135 | 0
height::TEXT_0.14 | 0
height::TEXT_0.145 | 0
height::TEXT_0.15 | 0
-[ RECORD 2 ]------+------
id | 2
sex | M
length | 0.35
diameter | 0.265
height | 0.09
rings | 7
height::TEXT_0.08 | 0
height::TEXT_0.085 | 0
height::TEXT_0.09 | 1
height::TEXT_0.095 | 0
height::TEXT_0.1 | 0
height::TEXT_0.11 | 0
height::TEXT_0.125 | 0
height::TEXT_0.13 | 0
height::TEXT_0.135 | 0
height::TEXT_0.14 | 0
height::TEXT_0.145 | 0
height::TEXT_0.15 | 0
etc
```
which does not seem to be PostgreSQL standard
---
