X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A7297D1B3E2 for ; Fri, 14 May 2004 12:07:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 32583-01 for ; Fri, 14 May 2004 12:07:03 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 41C0DD1B1E7 for ; Fri, 14 May 2004 12:07:03 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 8B478354F8; Fri, 14 May 2004 08:06:31 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 89DA8354F6; Fri, 14 May 2004 08:06:31 -0700 (PDT) Date: Fri, 14 May 2004 08:06:31 -0700 (PDT) From: Stephan Szabo To: Theodore Petrosky Cc: postgres SQL Subject: Re: where is this problem (trigger) In-Reply-To: <20040512175750.12624.qmail@web41006.mail.yahoo.com> Message-ID: <20040514080501.M35179@megazone.bigpanda.com> References: <20040512175750.12624.qmail@web41006.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/133 X-Sequence-Number: 17847 On Wed, 12 May 2004, Theodore Petrosky wrote: > I can not seem to update these rows because of the dot > in the jobnumber field. I have found that I can change > the dot to an underscore but I thought I would ask if > there is a better solution. > > here is the error: > > UPDATE jobinfo SET isbilled = false WHERE jobnumber = > '1162.01'; > ERROR: syntax error at or near ".01" at character 20 > CONTEXT: PL/pgSQL function "notify_jobinfo" line 2 at > execute statement