possible parser error - Mailing list pgsql-sql

From Kyle Bateman
Subject possible parser error
Date
Msg-id 3773EFA9.F354E501@actarg.com
Whole thread Raw
Responses Re: possible parser error
List pgsql-sql
I'm using v6.5.  I found out accidentally that the query: <p>update table set field = value' where key =
keyvalue;         --notice the accidental tick <p>silently ignores everything after the tick and does not generate any
kindof syntax error. <br />This quietly clobbered a table by updating the field in every record in the table.  (The
where<br />clause was ignored.) <p>The tick shouldn't have been there, it was just a typing error.  But unless I'm
missingsomething, <br />it seems like it would be good to generate an error like "Unmatched quotes" or some such thing.
<pre>-- 
 ----------------------------------------------------
 Kyle Bateman       President, Action Target Inc.
 "Viva Yo!"         kyle@actarg.com (801)377-8033x101
 ----------------------------------------------------</pre>  

pgsql-sql by date:

Previous
From: Jim Rowan
Date:
Subject: Re: [HACKERS] Re: trouble creating log table with rules
Next
From: Doug Younger
Date:
Subject: trigger to insert on update to non-existing row?