Re: Content for talk on Postgres Type System at PostgresConf - Mailing list pgsql-general

From Guyren Howe
Subject Re: Content for talk on Postgres Type System at PostgresConf
Date
Msg-id 372fd5d1-8d7c-411e-8a35-41793978e74b@Spark
Whole thread Raw
In response to Re: Content for talk on Postgres Type System at PostgresConf  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Content for talk on Postgres Type System at PostgresConf
Re: Content for talk on Postgres Type System at PostgresConf
Re: Content for talk on Postgres Type System at PostgresConf
List pgsql-general
In case I’m not correct on the issues with these types, myself, what are the misconceptions, or where might I find them for  myself?

My current understanding:
  • character is fixed-length, blank-padded. Not sure when you’d want that, but it seems clear. Is the name just confusing?
  • timestamptz is just converted to a timestamp in UTC. Folks might imagine that it stores the time zone but it doesn’t.
  • time with time zone *does* store the time zone, but this isn’t actually useful and should be avoided (I’m not entirely sure why and the docs only gesture at the problems without stating them, IIRC)
  • money is a fixed-point decimal value, the number of decimal places is locale determined. I’m not aware of any particular problems with that
On 29 Feb 2024 at 01:11 -0800, Laurenz Albe <laurenz.albe@cybertec.at>, wrote:
On Wed, 2024-02-28 at 17:08 -0800, Guyren Howe wrote:
I am to talk about Postgres’s type system at PGConf:

https://postgresconf.org/conferences/2024/program/proposals/postgres-s-type-system

I picked the issue because I think it’s poorly understood, greatly
under-discussed, and an excellent way to empower postgres users.

What would you want to see in such a talk?

It might be good to explain how "timestamp with time zone" works.
That's often confusing for beginners, because it is different from
other databases and arguably deviates from the SQL standard.

Perhaps it would be good to warn people about using data types like
"character", "time with time zone" and "money".

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: sud
Date:
Subject: Re: Question on Table creation
Next
From: Adrian Klaver
Date:
Subject: Re: Content for talk on Postgres Type System at PostgresConf