Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfcRa-001Cyb-Le for pgsql-general@arkaria.postgresql.org; Thu, 29 Feb 2024 09:11:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rfcRY-001cZk-N2 for pgsql-general@arkaria.postgresql.org; Thu, 29 Feb 2024 09:11:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfcRY-001cZb-CV for pgsql-general@lists.postgresql.org; Thu, 29 Feb 2024 09:11:08 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfcRU-0025UD-SD for pgsql-general@postgresql.org; Thu, 29 Feb 2024 09:11:07 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-412b83cfac4so4497235e9.0 for ; Thu, 29 Feb 2024 01:11:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1709197864; x=1709802664; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=dZvcuQaDSGTPEAF+7EGge7plmPhnal6FzHnC6zGlzpA=; b=uT9exKuOThYALlymOtBdmeXy6pjxnlO1PipCfoK8YTl++3KDbF27vEzDUCjfs1w3Ka aUNuK+4URACxwR1ME+8T00Fi+hvKi03+qb5BVZysmjq9E5B6PQzaMoKLbtwddj+n3+S0 rGpLfN5edEJ9CWONc+aX51PbwApGpqeGacWbWg48srArh+rAlMTes8YFbe8glKQ91dHT N/wBHnTd71Sn/pHKuV9MJ6Mk5F1Yeq0RMs4I8CkZ7QoOH2dYY3L8cq/xql4AwEY403IX B05EC7FBMui1MZt0ZqFhHEtdtBLYmwRz/dd5W62vU/OHfBamon3D0Uv9vm6M8hT0evUR 9sMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709197864; x=1709802664; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=dZvcuQaDSGTPEAF+7EGge7plmPhnal6FzHnC6zGlzpA=; b=PGvsWSH52Y/MCdVSzxycW92hKt8ihu+Nz6WC8u6hrH2VkNssGukmcXVEvHrCP/q83S Mft8zVz7RWEi3uktZdl5kaz9feKcoe+jMDc4RhQP9SOy1Kks1v7u59TJRLmsIBMi+xhy 2KyShIA3Zp8Nch+iSSgrYNDFYT3ZACsHWqPM2gXzEMtFpQHIRHPky7bg38cdy5Cfu1qb /pmqeL2VkR5J14jpxHScFwYVcYKZBGJH7QKUd70dIsUwvJ3Sl9uBOgu3pgpbV2qh07bf PytehK+H7QP62WuDBlBleZ7RtTbbIUmUnnfLO/mI84/BK/rmkFE3mJRfR39Z+lsMxWrs D+Cw== X-Forwarded-Encrypted: i=1; AJvYcCUWx6nog4BaLh0Kq5q+0igcj7pMhRXQL01jbeLkR7ab0LRZ5j5tz6l6hdj4z9RX9Vj5g14HeYbRzJhdemnJ9mq1BcAXRWZxurYNMzUw X-Gm-Message-State: AOJu0Yw09PtLYBSvjJQP/Si7nmdvsEd8hl/QxeGAuPiY5ci8B2X7Tk4f EFjTTi99+Gge6QcvqEqyvr4FaKV8Lns7xojne6JgwRKIk8ivBNcDICBlHgmZkLhTIhpTHSbAUKl X X-Google-Smtp-Source: AGHT+IGz5MFrAaW8gH8/s8MUdoqTzOKZ6RYZR/pWjPgzKOor9kWyB5+lkqjey/bPnh+EgVtOcYTSEg== X-Received: by 2002:a05:600c:154c:b0:412:9d49:64a3 with SMTP id f12-20020a05600c154c00b004129d4964a3mr1193401wmg.24.1709197864314; Thu, 29 Feb 2024 01:11:04 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:cf75:ce9a:f6a2:aa9c:105f]) by smtp.gmail.com with ESMTPSA id bd27-20020a05600c1f1b00b00411e3cc0e0asm1442878wmb.44.2024.02.29.01.11.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 29 Feb 2024 01:11:04 -0800 (PST) Message-ID: <08e99a8fa744e063ea31030d6516bfc64c26e3f8.camel@cybertec.at> Subject: Re: Content for talk on Postgres Type System at PostgresConf From: Laurenz Albe To: Guyren Howe , Postgres General Date: Thu, 29 Feb 2024 10:11:03 +0100 In-Reply-To: References: Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-02-28 at 17:08 -0800, Guyren Howe wrote: > I am to talk about Postgres=E2=80=99s type system at PGConf: >=20 > https://postgresconf.org/conferences/2024/program/proposals/postgres-s-ty= pe-system >=20 > I picked the issue because I think it=E2=80=99s poorly understood, greatl= y > under-discussed, and an excellent way to empower postgres users. >=20 > 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