2014-08-07 7:24 GMT+02:00 David Johnston david.g.johns...@gmail.com:
- What are the differences among PL/SQL, PL/PGSQL and pgScript.
The first two are languages you write functions in. pgScript is simply
an
informal way to group a series of statements together and have them
execute
I'm very new to Postgres, but have plenty of experience developing stored
procs in Oracle.
I'm going to be creating Postgres stored procedures (functions actually,
since I discovered that in postgres, everything is a function) to do a
variety of batch-type processing. These functions may or
Bill Epstein wrote
I've tried a variety of ways based on the on-line docs I've seen, but I
always get a syntax error on EXEC when I use only the line EXEC statement
You likely need to use EXECUTE in PostgreSQL
INFO: INSERT INTO UTILITY.BPC_AUDIT (COMPONENT, ACTIVITY, AUDIT_LEVEL,
On Aug 6, 2014, at 12:28 PM, Bill Epstein epste...@us.ibm.com wrote:
I'm very new to Postgres, but have plenty of experience developing stored
procs in Oracle.
I found this helpful:
Le 6 août 2014 18:47, David G Johnston david.g.johns...@gmail.com a
écrit :
Bill Epstein wrote
I've tried a variety of ways based on the on-line docs I've seen, but I
always get a syntax error on EXEC when I use only the line EXEC
statement
You likely need to use EXECUTE in PostgreSQL
- What are the differences among PL/SQL, PL/PGSQL and pgScript.
The first two are languages you write functions in. pgScript is simply
an
informal way to group a series of statements together and have them
execute
within a transaction.
AFAICT, this isn't true. Pgscript is a