diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2008-10-21 08:38:16 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2008-10-21 08:38:16 +0000 |
| commit | 1471e3843d04797ff117f84f6331b8b2e8fdd787 (patch) | |
| tree | e272add9a453af220026882c99586e0a722b584a /src/interfaces/ecpg/test/sql/parser.pgc | |
| parent | 089ae3bc9aa21c9a7eb38d9baa8ebdc6063c37db (diff) | |
Allow SQL:2008 syntax ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE
alongside our traditional syntax.
Diffstat (limited to 'src/interfaces/ecpg/test/sql/parser.pgc')
| -rw-r--r-- | src/interfaces/ecpg/test/sql/parser.pgc | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/interfaces/ecpg/test/sql/parser.pgc b/src/interfaces/ecpg/test/sql/parser.pgc index 97ccedda289..806aabb70f9 100644 --- a/src/interfaces/ecpg/test/sql/parser.pgc +++ b/src/interfaces/ecpg/test/sql/parser.pgc @@ -28,6 +28,9 @@ int main(int argc, char* argv[]) { for (i=0; i<3; i++) printf("item[%d] = %d\n", i, ind[i] ? -1 : item[i]); + EXEC SQL ALTER TABLE T ALTER Item1 TYPE bigint; + EXEC SQL ALTER TABLE T ALTER COLUMN Item2 SET DATA TYPE smallint; + EXEC SQL DROP TABLE T; EXEC SQL DISCONNECT ALL; |