aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/weak_field/weak_field_rest.sql
blob: a330421f3f1cee999e4e384d38402b9d54560b46 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
/* postgres can not */
USE plato;

--INSERT INTO Output
SELECT
    WeakField(animal, "String"),
    WeakField(size, "String") as sizeRating,
    WeakField(weightMin, "Float"),
    WeakField(weightMax, "Float"),
    WeakField(wild, "Bool"),
    WeakField(pet, "Bool", false),
    WeakField(miss, "Bool", true)
FROM Input
ORDER BY weightMin