Message-ID: <000c01c2c872$5d18ab80$0e01a8c0@aprote.com>
From: "Tambet Matiisen" <t.matiisen@aprote.ee>
To: "Thiago Conti" <thiago@nq.com.br>, "pgsql-sql" <pgsql-sql@postgresql.org>
References: <00d001c2c86f$8414dcc0$0c00000a@camburi>
Subject: Re: Function executing twice
Date: Thu, 30 Jan 2003 17:15:03 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I think you should first check your application logic, for example print
something out just before calling the function. Then you can easily see, if
the problem is in PostgreSQL or in your application.

I once had similar problem, when I used function as argument to COALESCE.
COALESCE is translated to CASE before evaluating the arguments. For example
COALESCE(id,nextval('id_seq')) becomes CASE WHEN id IS NOT NULL THEN id WHEN
nextval('id_seq') IS NOT NULL THEN nextval('id_seq') ELSE NULL END. As you
can see, when id is null, the sequence id_seq is incremented twice. Solution
was quite simple, I just used CASE directly: CASE WHEN id IS NOT NULL THEN
id ELSE nextval('id_seq') END.

  Tambet

----- Original Message -----
From: Thiago Conti
To: pgsql-sql
Sent: Thursday, January 30, 2003 4:54 PM
Subject: [SQL] Function executing twice


Hello,

I'm executing a function with this command:
select function_name(aaa,bbb,ccc);

When I do it on PSQL or PGAdmin it works perfectly.
However, on my application the function is executed twice.

Has anybody faced a problem like this?

I'm using PostgreSQL 7.2.3 and ODBC conection.

Thanks