Re: Using bind variable within BEGIN END

On Friday, June 2, 2017, gulsumramazanoglu <gulsumramazanoglu(at)gmail(dot)com>
wrote:

> David hi, if PostgreSQL doesnt have stored procedures and function can
> only be used by a SQL command, so we cannot make a call to an SQL script
> (of any kind, name it procedure or something) directly from a HLL program..
> do i understand correctly?
>

I don't think so but I cannot figure out what your actual confusion is.
Write a function. Execute a statement that invokes the function. Remain
connected until the function returns. Learn whether it completed
successfully or not and react accordingly. Move on in your HLL (higher
level language?) code.

The term procedure in sql often implies autonomous which client invoked
code cannot presently do (i.e., disconnect the connection after initiating
the code but before it completes).

Your syntax issues are mostly about not having read the right sections of
the docs pertaining to those syntactic issues. Once you get past that you
should be able to do most things that you can imagine.

David J.