Thread: BUG #2232: Function (store procedure) prublem

The following bug has been logged online:

Bug reference:      2232
Logged by:          Michael Grossman
Email address:      michael.grossnab@newconcept.co.il
PostgreSQL version: 8.1.2 windows
Operating system:   windows xp q windows 2003
Description:        Function (store procedure) prublem
Details:

Hi!

I am working have a year with PostgreSQL Windows Database.
I am very happy with the Database and its looks good.

I have to report of critical bug:
I am using functions (Store procedure) to update database.

When I passing for example 20 prams' to update a database its work fine.
But yesterday a saw when one of the parameters the value is – "109922:11"
I gut an error parameter 11 is empty – he thinks the value is a
parameter.
When a change this value to – "109922.11" the function works fine.

I working with the latest release 8.1.2 windows addition.

Michael Grossman wrote:
> When I passing for example 20 prams' to update a database its work fine.
> But yesterday a saw when one of the parameters the value is "109922:11"
> I gut an error parameter 11 is empty he thinks the value is a
> parameter.
> When a change this value to "109922.11" the function works fine.

You'll need to give some more details - can you produce a small function
that reproduces the error so others can test it on their machines?

--
   Richard Huxton
   Archonet Ltd

NOTE - wrong email address for Michael on my last reply.

Michael Grossman wrote:
> When I passing for example 20 prams' to update a database its work fine.
> But yesterday a saw when one of the parameters the value is "109922:11"
> I gut an error parameter 11 is empty he thinks the value is a
> parameter.
> When a change this value to "109922.11" the function works fine.

You'll need to give some more details - can you produce a small function
that reproduces the error so others can test it on their machines?

--
   Richard Huxton
   Archonet Ltd