Re: BUG #2139: Problem when calling functions without any argument - Mailing list pgsql-bugs

On 1/3/06, Jacques Gollion <jgollion@sambatechnologies.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2139
> Logged by:          Jacques Gollion
> Email address:      jgollion@sambatechnologies.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 powerbuild=
er
> 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.
>

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 ;)