Re: [SQL] Kind of error-handler in a pgsql function

2001-07-05 Thread DI Hasenöhrl
nsert ...  end if;end;On Wed, 4 Jul 2001, [iso-8859-1] DI Hasenöhrl wrote:> Hi,> > When I write in psql:> testdb=# update table1 set tableattribute='any' where table_nr=1;> if a tuple exists, I get this message > testdb=# update 1> if no tupl

[SQL] Kind of error-handler in a pgsql function

2001-07-04 Thread DI Hasenöhrl
Hi,   When I write in psql: testdb=# update table1 set tableattribute='any' where table_nr=1;     if a tuple exists, I get this message testdb=# update 1     if no tuple with table_nr=1 exists, I get this message testdb=# update 0       Is there a possibility to make a difference in a pgsq

[SQL] CAST Problem: Difference between insert a tuple in a table by function and by datasheet

2001-06-22 Thread DI Hasenöhrl
Now,I found the problem, but I don't know how to solve. It depends on type float8. I changed all type float to float8   In my function I make the following calculation: . update KalkPreislisten_float8 SET  kp_ep = rkontingent.k_ep::float8    -- this works correct   but I hav

[SQL] Difference between insert a tuple in a table by function and by datasheet

2001-06-22 Thread DI Hasenöhrl
Hi,   this is my 2nd attempt to get some links for my problem. I don't know whether my question is so stupid or difficult or I'm in the wrong list. Please let me know.   I have the following situation: ( I use MsAccess97 as frontend, ODBC 7.1.0003) I insert tuples in a table with a plpgsql-fu

[SQL] Problem by inserting rows in a table via function

2001-06-21 Thread DI Hasenöhrl
Hello all,   I use postgresql 7.0.2 as backend, ODBC Driver 7.1.003 and MsAccess97 as frontend. Now I have the following Problem and hope, someone can help me.   I developed a function in plpgsql, which inserts rows in a table *price*. This function is called from VBA-Code and everything se

[SQL] How to create a *pass-through-query* in postgresql

2001-06-06 Thread DI Hasenöhrl
Hello all,   I use postgresql as backend and MsAccess97 as frontend via ODBC. I know, how to use VBA and pass through queries to update or insert rows in postgresql-tables. But I don't know, how to do this the other way round, from postgresql to MsAccess. I want to develop a trigger, which u

[SQL] ERROR: Class '37632' not found

2001-05-30 Thread DI Hasenöhrl
Hello,   I have a problem to drop a rule from my database.   When I want to create a rule *r_name*, I get the message, that this rule still exists and when I want to drop my rule *r_name*, I get the message: Class '37632' not found   Please, can anyone help me to solve this problem. Thanks i