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