Re: [GENERAL] Problems with plpgsql and FOR loops

2004-06-05 Thread Bill Moran
V i s h a l Kashyap @ [Sai Hertz And Control Systems] wrote: Dear Bill Moran , I know the correct solution is to use the same version to develop on that I'm using to test. So I'm going to downgrade my version to 7.3.4 for now ... but this doesn't solve my biggest problem: getting the FOR loop to

Re: [GENERAL] Problems with plpgsql and FOR loops

2004-06-05 Thread Tom Lane
Bill Moran <[EMAIL PROTECTED]> writes: > Some of the plpgsql functions I've created work fine on 7.4, but > fail on 7.3.4. Specifically, when I use a "FOR var IN select LOOP" > loop with a LONG select statement, it works fine on 7.4, but > bonks with "missing .. at end of SQL expression" in 7.3.4

Re: [GENERAL] Problems with plpgsql and FOR loops

2004-06-05 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Bill Moran , I know the correct solution is to use the same version to develop on that I'm using to test. So I'm going to downgrade my version to 7.3.4 for now ... but this doesn't solve my biggest problem: getting the FOR loop to work. It appears from the error that the parser is getting c

Re: [GENERAL] Problems with plpgsql and FOR loops

2004-02-20 Thread Bill Moran
Tom Lane wrote: Bill Moran <[EMAIL PROTECTED]> writes: Some of the plpgsql functions I've created work fine on 7.4, but fail on 7.3.4. Specifically, when I use a "FOR var IN select LOOP" loop with a LONG select statement, it works fine on 7.4, but bonks with "missing .. at end of SQL expression"