Benjamin Krajmalnik wrote: > update tblksalerts set cleartime = '2009-07-29 10:49:50'::TIMESTAMP, > laststatusid = 7::INTEGER, lastreplytext = '0'::VARCHAR, lasttesttime = > '2009-07-29 10:49:50'::TIMESTAMP, lasteventsource is NULL::VARCHAR, > lasteventid is NULL::INTEGER, replyval = 0::REAL, trend = ''::varchar ( > 1 ), alertoccurrence = 0::integer where ksalertssysid = 1737078 > Please note the "lasteventsource is null" instead of "lasteventsource = > null" which is being generated when the value of x_eventsource is null. Do you have transform_null_equals set? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
