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