SEO

#1 (**permalink**) 04-10-2008, 09:36 AM

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

#2 (**permalink**) 04-10-2008, 09:36 AM

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

BUG #2139: Problem when calling functions without any argument