X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 82C438B9E7A for ; Wed, 23 Feb 2005 10:20:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40257-06 for ; Wed, 23 Feb 2005 10:19:54 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id F03EB8B9E71 for ; Wed, 23 Feb 2005 10:19:55 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 5C3E331474; Wed, 23 Feb 2005 11:19:55 +0100 (MET) From: bertolima@yahoo.it (mauro) X-Newsgroups: pgsql.sql Subject: Postgres 8 - problem: invalid input syntax for integer Date: 23 Feb 2005 02:19:53 -0800 Organization: http://groups.google.com Lines: 15 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/287 X-Sequence-Number: 20397 Hi, In previous version di Postgres (7.2) I used this table: CREATE TABLE tablename (id serial, field int1, field2 text); Now this query work: UPDATE tablename SET field1=''; (NOTE: implicit conversion to 0) UPDATE tablename SET field2=''; (this cause of simple code-generation query - I don't know what's field type) Now in postgres 8 this don't work. Why ?(ok, it's the ufficial documentation but I don't understand... why? it's so comfortable!) Can someone help me to create a CAST to re-use this feature? Thank you! Mauro