undetected1
/ postsql.sql
Created
May 17, 2012 16:53
— forked from tobyhede/postsql.sql
PostgreSQL as JSON Document Store
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- PostgreSQL 9.2 beta (for the new JSON datatype) | |
| -- You can actually use an earlier version and a TEXT type too | |
| -- PL/V8 http://code.google.com/p/plv8js/wiki/PLV8 | |
| -- JSON Types need to be mapped into corresponding PG types | |
| -- | |
| -- Number => INT or DOUBLE PRECISION | |
| -- String => TEXT |