Обсуждение: 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