svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / testJsonValue.sql @ 46193
History | View | Annotate | Download (401 Bytes)
| 1 |
|
|---|---|
| 2 |
-- test Json Value Function SQL
|
| 3 |
|
| 4 |
-- JsonValueWhere
|
| 5 |
SELECT "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", NVL2("Geometry",ST_AsBinary("Geometry"),NULL), JSON_VALUE("String", '$.acc_cit') AS "JsonValue1" FROM "PUBLIC"."test" WHERE (JSON_VALUE("String", '$.acc_cit') = 1) ORDER BY "ID" ASC NULLS LAST; |
| 6 |
|
| 7 |
-- Count
|
| 8 |
|