"Minal A. Aryamane" <minalac@yes2etl.com> writes:
> Can anyone tell me why the same function tried on POSTGRESQL 7.4 works =
> but does nor work on POSTGRESQL 8.0. Is there any difference in the way =
> POSTGRES handles functions in version 8.0
There are some ... but the code you show would not have worked in *any*
release of PG. It's certainly missing a BEGIN, and "SET" is not the
syntax for assigning to a local plpgsql variable, and quite a few
semicolons are obviously missing, and you didn't bother to return any
result value.
Could we have an unedited transcription of both the function source code
and the error message, please?
regards, tom lane