postgres.git / summary / log / commit / refs

commit    efb224a4392326fd6ae3eabdc170a246978d3f09
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Tue Jun 14 19:53:02 2011 +0000
First released in: 9.2.0

    Add comment that attributes.is_nullable was removed from SQL standard
    
    We don't have to remove the column if no one is bothered, but it's
    useful to comment on it in case someone looks for it in newer
    standards versions.


 src/backend/catalog/information_schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql
index 452a0ead44c..81407a3a5ee 100644
--- a/src/backend/catalog/information_schema.sql
+++ b/src/backend/catalog/information_schema.sql
@@ -274,7 +274,7 @@ CREATE VIEW attributes AS
            CAST(pg_get_expr(ad.adbin, ad.adrelid) AS character_data) AS attribute_default,
            CAST(CASE WHEN a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) THEN 'NO' ELSE 'YES' END
              AS yes_or_no)
-             AS is_nullable,
+             AS is_nullable, -- This column was apparently removed between SQL:2003 and SQL:2008.
 
            CAST(
              CASE WHEN t.typelem <> 0 AND t.typlen = -1 THEN 'ARRAY'


[parent: 07d17a73ec94]