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