Skip site navigation (1) Skip section navigation (2)

Re: Help with DELETE statement via ODBC

From: Carlos Abalde <carlos(at)lfcia(dot)org>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Steve Lutz <slutz(at)highbeam(dot)com>
Subject: Re: Help with DELETE statement via ODBC
Date: 2004-06-08 07:54:10
Message-ID: 20040608075410.GA7613@lfcia.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Steve Lutz wrote...

> If we are going to turn this into a Philosophical discussion, what
> happens when a select statement updates zero rows? It doesn't cause an
> error, why does a delete?

Hi Steve!

In my previous mail I wrote about DELETE statement because I want
to focus in a specific problem, but I think that the behaviour of
the UPDATE statement is erroneous too. The reasons are exactly the
same as for the DELETE statement. Once again the Sets Theory behind
DBs is the main reason. 0 updated rows must not be an ODBC/DB error. 
Maybe 0 updated rows is an application (DB client) error, but that is
a decission of the application. DBs only known about sets of tuples.

Cheers,


+---.---.---.---.---.---.---.---.---+---.---.---.---.---.---.---.---+
| Carlos Abalde (carlos(at)lfcia(dot)org)  | http://www.lfcia.org/~carlos  |
+ LFCIA Lab, Dept. Computer Science | +34.981.167000 ext. 1275      +
| University of A Coruna, Spain     | PGP Key ID = 0x04DF0EAF       |
+-.---.---.---.---.---.---.---.---.-+-.---.---.---.---.---.---.---.-+

In response to

pgsql-odbc by date

Next:From: Marius NedelcuDate: 2004-06-09 10:09:20
Subject: problems with psqlODBC
Previous:From: Steve LutzDate: 2004-06-08 00:03:31
Subject: Re: Help with DELETE statement via ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group