The following bug has been logged online:

Bug reference: 2139
Logged by: Jacques Gollion
Email address: jgollion (AT) sambatechnologies (DOT) com
PostgreSQL version: 8.1.1
Operating system: Windows 2000
Description: Problem when calling functions without any argument
Details:

have have written some functions without any argument. When my powerbuilder
V9 application calls these functions, the behaviour is different :

*Using ODBC driver, it works well
*Using JDBC driver (I tried several versions), I get the error message
"ERROR : Syntax error at or near $1. If I add a unused argument to the
function; it works.
If I call in JDBC the same function for Oracle or Sybase, it works.
If I call other PostGreSQL functions with arguments, it works.

Where am I wrong ?

Thanks in advance for your help.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On 1/3/06, Jacques Gollion <jgollion (AT) sambatechnologies (DOT) com> wrote:
and... where is the function? how is defined? how do you use it?

code, please wiyhout that you can't expect any help...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jaime Casanova wrote:
Yup, need some examples. Remember though that ODBC, JDBC, and native
Postgresql are different dialects, with some differences in
implementation. My guess is that the Postgresql has a return value,
JDBC detects it, and really wants a placeholder for it and ODBC
didn't. Note also that each DB can have some different syntaxes,
capabilities and conventions.

ODBC/JDBC can reduce significantly the differences. They both have
some escape sequences that can help, but are not the same as the ANSI
Sql.

Jay Grubb
Technical Consultant
OpenLink Software
Web: http://www.openlinksw.com:
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology Providers