Re: BUG #2139: Problem when calling functions without any

hello Jaime,

Sorry. I forgot to provide you with the information. Please find the function and
the trace of jdbc calls in the enclosed file.

Thank you in advance for your help.

Jacques

Jaime Casanova a écrit :

> On 1/3/06, Jacques Gollion <jgollion(at)sambatechnologies(dot)com> wrote:
> >
> > 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.
> >
>
> 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 ;)

--
________________________________________________________________________
Jacques GOLLION mailto:jgollion(at)sambatechnologies(dot)com
SAMBA Technologies http://www.sambatechnologies.com
53 chemin du Vieux Chene Phone : +33 (0) 4 76 04 00 59
38240 MEYLAN FRANCE Fax : +33 (0) 4 76 04 15 98
________________________________________________________________________