diff options
Diffstat (limited to 'src/interfaces/ecpg/test/sql/parser.pgc')
| -rw-r--r-- | src/interfaces/ecpg/test/sql/parser.pgc | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/interfaces/ecpg/test/sql/parser.pgc b/src/interfaces/ecpg/test/sql/parser.pgc index e7115b94726..f569e43a1d5 100644 --- a/src/interfaces/ecpg/test/sql/parser.pgc +++ b/src/interfaces/ecpg/test/sql/parser.pgc @@ -19,9 +19,9 @@ int main() { EXEC SQL CREATE TABLE T ( Item1 int, Item2 int ); - EXEC SQL INSERT INTO T VALUES ( 1, null ); - EXEC SQL INSERT INTO T VALUES ( 1, 1 ); - EXEC SQL INSERT INTO T VALUES ( 1, 2 ); + EXEC SQL INSERT INTO t + SELECT 1,nullif(y-1,0) + FROM generate_series(1,3) WITH ORDINALITY AS series(x,y); EXEC SQL SELECT Item2 INTO :item:ind FROM T ORDER BY Item2 NULLS LAST; |