Re: [SQL] Function executing twice

2003-01-30 Thread Tambet Matiisen
ice. 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&

[SQL] Function executing twice

2003-01-30 Thread Thiago Conti
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.