čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus <x...@thebuild.com> 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 from the terminal > already: just use psql, connect to the database, and create and run > functions and procedures as much as you like. > > If the question is, "Have there been any efforts to implement a PL/pgSQL > interpreter without PostgreSQL?", that's a different and much more complex > problem. PL/pgSQL uses the PostgreSQL query execution machinery to run > pretty much anything that is not a control structure, and the language is > very focused on interacting with the database. I doubt it would be worth > anyone's time to try to build some kind of minimal framework that > implements the SPI to allow PL/pgSQL to operate without PostgreSQL. > yes plpgsql cannot exist without Postgres. PL/pgSQL is strongly reduced interpreted Ada language. The gcc compiler supports Ada language. I found https://bush.sourceforge.net/bushref.html - it is interpret with Ada syntax, but it is better to learn Python - it is easy - with a pretty big library. free pascal https://www.freepascal.org/ is good compiler and you can write terminal applications too - with Turbo Vision Regards Pavel
