diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-04-10 11:18:15 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-04-10 11:18:15 -0400 |
| commit | 244f1c89070c1a661623bf1eaddf1307f8f598a3 (patch) | |
| tree | 4d2485cebe07f5a5ee30400f10ea458fbc18d910 /contrib/sepgsql/sql/dml.sql | |
| parent | 511540dadf1166d80b864f63979178f324844060 (diff) | |
| download | postgresql-244f1c89070c1a661623bf1eaddf1307f8f598a3.tar.gz | |
Fix whitespace
Diffstat (limited to 'contrib/sepgsql/sql/dml.sql')
| -rw-r--r-- | contrib/sepgsql/sql/dml.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/sepgsql/sql/dml.sql b/contrib/sepgsql/sql/dml.sql index fc318110fa..19201f4b90 100644 --- a/contrib/sepgsql/sql/dml.sql +++ b/contrib/sepgsql/sql/dml.sql @@ -158,14 +158,14 @@ UPDATE t5 SET e = g || '_upd'; -- failed --- -- partitioned table parent UPDATE t1p SET o = 9 WHERE o < 10; -- ok -UPDATE t1p SET o = 99 WHERE o >= 10; -- ok +UPDATE t1p SET o = 99 WHERE o >= 10; -- ok UPDATE t1p SET o = ascii(COALESCE(p,'upd'))%10 WHERE o < 10; -- ok UPDATE t1p SET o = ascii(COALESCE(q,'upd'))%100 WHERE o >= 10; -- failed -- partitioned table children UPDATE t1p_ones SET o = 9; -- ok UPDATE t1p_ones SET o = ascii(COALESCE(p,'upd'))%10; -- ok UPDATE t1p_ones SET o = ascii(COALESCE(q,'upd'))%10; -- failed -UPDATE t1p_tens SET o = 99; -- ok +UPDATE t1p_tens SET o = 99; -- ok UPDATE t1p_tens SET o = ascii(COALESCE(p,'upd'))%100; -- ok UPDATE t1p_tens SET o = ascii(COALESCE(q,'upd'))%100; -- failed --- |