Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

2021-12-17 Thread Bryn Llewellyn
> p...@bowt.ie wrote: > >> b...@yugabyte.com wrote: >> >> Modular design recommends exposing functionality through a purpose oriented >> interface and hiding all implementation details from the API’s user. A >> package achieves this with declarative syntax via the spec/body separation. >> The

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

2021-12-17 Thread Peter Geoghegan
On Fri, Dec 17, 2021 at 11:43 AM Bryn Llewellyn wrote: > Modular design recommends exposing functionality through a purpose oriented > interface and hiding all implementation details from the API’s user. A > package achieves this with declarative syntax via the spec/body separation. > The body

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

2021-12-17 Thread Bryn Llewellyn
laurenz.a...@cybertec.at wrote: > >> b...@yugabyte.com wrote: >> >> The advantages are self-evident to these programmers… > > I am not trying to belittle this, but when you are used to system A and start > working with system B you always miss some features of A, until you get to > know B

Re: SELECT DISTINCT scans the table?

2021-12-17 Thread Markus Demleitner
Dear Tom, On Thu, Dec 16, 2021 at 03:47:57PM -0500, Tom Lane wrote: > Markus Demleitner writes: > > Maximally stripped down, my problem is that > > > select distinct 300 from > > > seqscans (at least in PostgreSQL 11.14). To me, it seems > > obvious that this ought be be just one row