information_schema.view attgenerated
От | jian he |
---|---|
Тема | information_schema.view attgenerated |
Дата | |
Msg-id | CACJufxHO3=BA=9S1RAG3=Rp_E=C_ShO9UFfTniEHdMTp4mTS9A@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: information_schema.view attgenerated
|
Список | pgsql-hackers |
hi. one minor issue in src/backend/catalog/information_schema.sql /* * 6.22 * COLUMNS view */ CREATE VIEW columns .... CAST(CASE WHEN a.attgenerated = '' THEN pg_get_expr(ad.adbin, ad.adrelid) END AS character_data) AS column_default, can change to CAST(CASE WHEN a.attgenerated = '' AND a.atthasdef THEN pg_get_expr(ad.adbin, ad.adrelid) END AS character_data) AS column_default, CAST(CASE WHEN a.attgenerated <> '' THEN 'ALWAYS' ELSE 'NEVER' END AS character_data) AS is_generated, can change to CAST(CASE WHEN a.attgenerated <> '' AND a.atthasdef THEN 'ALWAYS' ELSE 'NEVER' END AS character_data) AS is_generated, CAST(CASE WHEN a.attgenerated <> '' THEN pg_get_expr(ad.adbin, ad.adrelid) END AS character_data) AS generation_expression, can change to CAST(CASE WHEN a.attgenerated <> '' AND a.atthasdef THEN pg_get_expr(ad.adbin, ad.adrelid) END AS character_data) AS generation_expression, i guess, it will have some minor speed up, also more accurate.
В списке pgsql-hackers по дате отправления: