Re: information_schema.view attgenerated

2024-09-29 Thread Peter Eisentraut
On 18.09.24 10:23, jian he wrote: On Wed, Sep 18, 2024 at 4:09 PM Peter Eisentraut wrote: i guess, it will have some minor speed up, also more accurate. I'm having a hard time interpreting this report. Could you be more clear about what is the existing code, and what is the code you are p

Re: information_schema.view attgenerated

2024-09-18 Thread jian he
On Wed, Sep 18, 2024 at 4:09 PM Peter Eisentraut wrote: > > > > > i guess, it will have some minor speed up, also more accurate. > > I'm having a hard time interpreting this report. Could you be more > clear about what is the existing code, and what is the code you are > proposing as new.? > sor

Re: information_schema.view attgenerated

2024-09-18 Thread Peter Eisentraut
On 16.09.24 06:12, jian he wrote: 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(C

information_schema.view attgenerated

2024-09-15 Thread jian he
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.atth