PostgreSQL JDBC - Re: [ODBC] Stored Procedures

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [ODBC] Stored Procedures

Tom Lane

2006-01-16, 1:23 pm

"Minal A. Aryamane" <minalac@yes2etl.com> writes:
> the function is as below:
> ...
> SET COURSEIDS1:=COURSEID
S;
> ...

This is completely off-topic for both the lists you have chosen, but
I'd say the problem is that you must not use the SET keyword when
assigning to a plpgsql local variable.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links