|
4 | 4 | * |
5 | 5 | * Copyright 2003, PostgreSQL Global Development Group |
6 | 6 | * |
7 | | - * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.17 2003/11/29 22:39:40 pgsql Exp $ |
| 7 | + * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.18 2003/12/07 10:21:58 petere Exp $ |
8 | 8 | */ |
9 | 9 |
|
10 | 10 | /* |
@@ -260,12 +260,16 @@ CREATE VIEW columns AS |
260 | 260 |
|
261 | 261 | CAST( |
262 | 262 | CASE WHENt.typtype='d' THEN |
263 | | - CASE WHENt.typbasetypeIN (25,1042,1043,1560,1562)ANDt.typtypmod<>-1 |
264 | | - THENt.typtypmod-4 |
| 263 | + CASE WHENt.typbasetypeIN (1042,1043)ANDt.typtypmod<>-1 |
| 264 | + THENt.typtypmod-4/* char, varchar*/ |
| 265 | + WHENt.typbasetypeIN (1560,1562)ANDt.typtypmod<>-1 |
| 266 | + THENt.typtypmod/* bit, varbit*/ |
265 | 267 | ELSEnull END |
266 | 268 | ELSE |
267 | | - CASE WHENa.atttypidIN (25,1042,1043,1560,1562)ANDa.atttypmod<>-1 |
| 269 | + CASE WHENa.atttypidIN (1042,1043)ANDa.atttypmod<>-1 |
268 | 270 | THENa.atttypmod-4 |
| 271 | + WHENa.atttypidIN (1560,1562)ANDa.atttypmod<>-1 |
| 272 | + THENa.atttypmod |
269 | 273 | ELSEnull END |
270 | 274 | END |
271 | 275 | AS cardinal_number) |
@@ -559,8 +563,10 @@ CREATE VIEW domains AS |
559 | 563 | AS data_type, |
560 | 564 |
|
561 | 565 | CAST( |
562 | | - CASE WHENt.typbasetypeIN (25,1042,1043,1560,1562)ANDt.typtypmod<>-1 |
563 | | - THENt.typtypmod-4 |
| 566 | + CASE WHENt.typbasetypeIN (1042,1043)ANDt.typtypmod<>-1 |
| 567 | + THENt.typtypmod-4/* char, varchar*/ |
| 568 | + WHENt.typbasetypeIN (1560,1562)ANDt.typtypmod<>-1 |
| 569 | + THENt.typtypmod/* bit, varbit*/ |
564 | 570 | ELSEnull END |
565 | 571 | AS cardinal_number) |
566 | 572 | AS character_maximum_length, |
|