Hello,

Consider:

template1=# create table baz (test numeric);
CREATE TABLE
template1=# insert into baz values (5);
INSERT 17259 1
template1=# insert into baz values (5);
INSERT 17260 1
template1=# insert into baz values (5);
INSERT 17261 1
template1=# insert into baz values (5);
INSERT 17262 1
template1=# insert into baz values (5);
INSERT 17263 1
template1=# insert into baz values (5);
INSERT 17264 1
template1=# insert into baz values (6);
INSERT 17265 1
template1=# insert into baz values (6);
INSERT 17266 1
template1=# insert into baz values (6);
INSERT 17267 1
template1=# insert into baz values (6);
INSERT 17268 1
template1=# insert into baz values (6);
INSERT 17269 1

template1=# select * from baz;
 test
------
    5
    5
    5
    5
    5
    5
    6
    6
    6
    6
    6
(11 rows)


template1=# update baz set test = test - 3; UPDATE 11 template1=# select * from baz; test ------ 2 2 2 2 2 2 3 3 3 3 3 (11 rows)

template1=# update baz set test = test - -3;
UPDATE 11

template1=# select * from baz;
 test
------
    5
    5
    5
    5
    5
    5
    6
    6
    6
    6
    6
(11 rows)

template1=# update baz set test = test--3;
template1-#

Here this system does not pick up the semi colon. I have to enter a second semi colon to get the update to happen.

template1=# update baz set test = test--3;
template1-# ;
UPDATE 11

This is on Fedora Core 2 with Beta 3.

Sincerely,

Joshua D. Drake



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We  provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored  the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to