2014-08-07 7:24 GMT+02:00 David Johnston :
>
>> > > - 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
>> > with
>
>
> > > - 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
Le 6 août 2014 18:47, "David G Johnston" 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
>
>
> >INFO:
On Aug 6, 2014, at 12:28 PM, Bill Epstein wrote:
> I'm very new to Postgres, but have plenty of experience developing stored
> procs in Oracle.
>
I found this helpful:
http://www.amazon.com/PostgreSQL-Server-Programming-Hannu-Krosing-ebook/dp/B00DMYO2D2/ref=tmm_kin_swatch_0?_encoding=UTF8&
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,
>
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 may
