Re: How to plpgsql scripting

2020-03-25 Thread Ekaterina Amez
El mié., 25 mar. 2020 a las 13:54, David G. Johnston (< david.g.johns...@gmail.com>) escribió: > On Wednesday, March 25, 2020, Ekaterina Amez > wrote: >> >> What's wrong with the syntax? Or is not possible to make a script and I >> have to create a function to encapsulate my code? >> > This not w

Re: How to plpgsql scripting

2020-03-25 Thread Ekaterina Amez
El mié., 25 mar. 2020 a las 13:42, Pavel Stehule () escribió: > > just this is not supported feature. > I was affraid this was going to be the answer.. sigh > You have some special reason why you use 8.4? It's pretty old unsupported > version. > As I said: legacy server. I'm planning upgrade i

Re: How to plpgsql scripting

2020-03-25 Thread David G. Johnston
On Wednesday, March 25, 2020, Ekaterina Amez wrote: > > What's wrong with the syntax? Or is not possible to make a script and I > have to create a function to encapsulate my code? > This not working exactly the reason the “DO” command was created. David J.

Re: How to plpgsql scripting

2020-03-25 Thread Pavel Stehule
st 25. 3. 2020 v 13:20 odesílatel Ekaterina Amez napsal: > Hi List, > > I'm used to make my own scripts in Oracle plsql, Sql Server tsql... but > I'm unable to make one simple script in Postgres. > > Objective version is 8.4 (I know, I know... it's a legacy server, I'm > planning upgrade this ser

How to plpgsql scripting

2020-03-25 Thread Ekaterina Amez
Hi List, I'm used to make my own scripts in Oracle plsql, Sql Server tsql... but I'm unable to make one simple script in Postgres. Objective version is 8.4 (I know, I know... it's a legacy server, I'm planning upgrade this server as soon as I can). I have a test server with 9.2 version wher