Re: Thoughts on user-defined types for talk at Postgres conference?

2024-03-07 Thread Tom Lane
"Peter J. Holzer" writes: > On 2024-03-06 12:45:33 -0500, Stephen Frost wrote: >> That's an additional 21 bytes, which is really quite a lot. What's >> included in those 21 bytes are >> [...] >> the type information (typmod if there is one and the OID of the >> composite type), > Is it necessary

Re: Thoughts on user-defined types for talk at Postgres conference?

2024-03-07 Thread Peter J. Holzer
On 2024-03-06 12:45:33 -0500, Stephen Frost wrote: > =*# select pg_column_size(t2.*) from t2; > pg_column_size > > 53 > (1 row) > > That's an additional 21 bytes, which is really quite a lot. What's > included in those 21 bytes are [...] > the type information (typ

Re: Is partition pruning impacted by data type

2024-03-07 Thread sud
Something interesting and not sure if expected behaviour is as below. We are confused here. In the below example we created two partitioned tables on timestamptz type columns with different time zones and the child partitions are created appropriately with boundaries as one mid night to next mid n

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Adrian Klaver
On 3/7/24 12:20, Achilleas Mantzios wrote: Στις 7/3/24 21:29, ο/η Adrian Klaver έγραψε: On 3/7/24 10:13, Achilleas Mantzios wrote: Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: I am not talking for fun. I am talking about the future programmers of this world. Teaching Python or C to them upo

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Achilleas Mantzios
Στις 7/3/24 21:29, ο/η Adrian Klaver έγραψε: On 3/7/24 10:13, Achilleas Mantzios wrote: Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: I am not talking for fun. I am talking about the future programmers of this world. Teaching Python or C to them upon arrival to the classes seems so wrong in

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Adrian Klaver
On 3/7/24 10:13, Achilleas Mantzios wrote: Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: I am not talking for fun. I am talking about the future programmers of this world. Teaching Python or C to them upon arrival to the classes seems so wrong in every aspect. Seems to me you need to tackle

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Karsten Hilbert
Am Thu, Mar 07, 2024 at 08:04:21PM +0200 schrieb Achilleas Mantzios: > > Python 3.11.2 (main, Mar 13 2023, 12:18:29) [GCC 12.2.0] on linux > > Type "help", "copyright", "credits" or "license" for more information. > > >>> for idx in [0,1,2,3]: print(idx) > > Dude this is like saying th

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Achilleas Mantzios
Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: On Thu, Mar 7, 2024 at 11:26 AM Pavel Stehule wrote: čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud wrote: So, I ask, have there been any efforts to bring PL/PGSQL to the terminal?

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Achilleas Mantzios
Στις 7/3/24 18:25, ο/η Pavel Stehule έγραψε: čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: > On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud wrote: > So, I ask, have there been any efforts to bring PL/PGSQL to the terminal? Strictly speaking, of cou

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Achilleas Mantzios
Στις 7/3/24 17:13, ο/η Karsten Hilbert έγραψε: Am Thu, Mar 07, 2024 at 04:56:18PM +0200 schrieb Achilleas Mantzios - cloud: Python IMHO is too advanced, too rich, Python _is_ powerful but it needn't be difficult. weird indentation rules A matter of taste IMO. no simple for loop Really ?

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Robert Treat
On Thu, Mar 7, 2024 at 11:26 AM Pavel Stehule wrote: > čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: >> > On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud >> > wrote: >> > So, I ask, have there been any efforts to bring PL/PGSQL to the terminal? >> >> Strictly speaking, of cour

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Markur Sens
> On 7 Mar 2024, at 4:56 PM, Achilleas Mantzios - cloud > wrote: > > Hello > > I notice both my kids struggling with either C or Python as first programming > languages. I believe both are unsuitable for use as introductory languages to > college juniors. https://scratch.mit.edu/ would be

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Adrian Klaver
On 3/7/24 06:56, Achilleas Mantzios - cloud wrote: Hello I notice both my kids struggling with either C or Python as first programming languages. I believe both are unsuitable for use as introductory languages to college juniors. What the cool kids are using:)? https://www.rust-lang.org/ h

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Pavel Stehule
čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: > > > > On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud < > a.mantz...@cloud.gatewaynet.com> wrote: > > So, I ask, have there been any efforts to bring PL/PGSQL to the terminal? > > Strictly speaking, of course, you can use PL/pgSQL

Re: v11.5- v15.3 upgrade (linux)

2024-03-07 Thread Adrian Klaver
On 3/7/24 07:47, David Gauthier wrote: Please reply to list also. Ccing list >>I would definitely read the release notes for 12.0, 13.0, 14.0 and 15.0. Check !  None of the breaking changes affect me. >>How are and from where are you installing the Postgres package(s)? IT does the installs

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Christophe Pettus
> On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud > wrote: > So, I ask, have there been any efforts to bring PL/PGSQL to the terminal? Strictly speaking, of course, you can use PL/pgSQL from the terminal already: just use psql, connect to the database, and create and run functions and

Re: v11.5- v15.3 upgrade (linux)

2024-03-07 Thread Ron Johnson
Bug fixes for problems (like slow queries) you didn't realize you had, or would have if you later implemented a feature with the bug. (For example, an aggravating weekly manual activity disappeared when I was allowed to update from 9.6.6 to 9.6.24.) And, of course, security bug fixes, Won't you

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Karsten Hilbert
Am Thu, Mar 07, 2024 at 04:56:18PM +0200 schrieb Achilleas Mantzios - cloud: > Python IMHO is too advanced, too rich, Python _is_ powerful but it needn't be difficult. > weird indentation rules A matter of taste IMO. > no simple for loop Really ? Python 3.11.2 (main, Mar 13 2023, 12:

pl/pgsql outside the DB, (i.e. on the terminal) possible ?

2024-03-07 Thread Achilleas Mantzios - cloud
Hello I notice both my kids struggling with either C or Python as first programming languages. I believe both are unsuitable for use as introductory languages to college juniors. Python IMHO is too advanced, too rich, weird indentation rules, no simple for loop etc. C, ok, punishing little