Στις 7/3/24 18:25, ο/η Pavel Stehule έγραψε:
č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.
Cool, thank you.
free pascal https://www.freepascal.org/ is good compiler and you can
write terminal applications too - with Turbo Vision
Too bad, PASCAL is now neglected by most UNIs :(
Regards
Pavel
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)