Thread: Parse Error neaer NullOrder
I'm getting an error when my plpgsql function in 7.2.3 is called from Java. The error is Parse Error Near NullOrder. When does this error occur. The function worked fine when I removed the Order By Clause from it. But then When i checked....The field that I was using in the order by clause, did not contain any null values. Then Why did I get this error and why did it work when i removed the clause? I need to insert it again. PLease someone Suggest something. POstgres is functining cray in many situations. Neither does not have a proper documentayion of error codes nor does it throw errors when it should be thowing errors. Thanx Madhavi
Madhavi Daroor wrote: > The error is > Parse Error Near NullOrder. > > When does this error occur. The function worked fine when I removed the > Order By Clause from it. Try adding a space before your "order by"? > PLease someone Suggest something. POstgres is functining cray in many > situations. Neither does not have a proper documentayion of error codes nor > does it throw errors when it should be thowing errors. When does it not throw errors when it should be throwing errors? -- Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 12:30pm up 210 days, 3:35, 6 users, load average: 5.03, 5.19, 5.33