[GRASSLIST:8340] RE: db.execute syntax

[Trevor Wiens]

On Mon, 19 Sep 2005 17:19:00 +0100
Glynn Clements <glynn at gclements.plus.com> wrote:

> 
> Patton, Eric wrote:
> 
> > echo 'UPDATE Opil184a_ship_nav_med_smth SET MOD_60 = 1 WHERE CAT % 60 = 0' | db.execute
>                                                                         ^
> 
> Here you've made the opposite mistake, using '=' for an equality check
> when it should be '=='.
> 

Glynn,

Correct me if I'm wrong but to my knowledge == and = are not used in SQL the way they are in C for example. In fact AFAIK == is not used at all in standard SQL, it isn't referenced in the PostgreSQL documentation for 8.0 that I can find.

T
-- 
Trevor Wiens
twiens at interbaun.com

The greatest obstacle to discovery is not ignorance - it is the illusion of knowledge.
(Daniel J. Boorstin)