Received: from proxy.bazzanese.com (sferac@ip135.tol11.interbusiness.it [195.120.106.135]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA05820 for ; Thu, 4 Jun 1998 05:17:33 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id KAA01054; Thu, 4 Jun 1998 10:30:59 GMT Date: Thu, 4 Jun 1998 10:30:59 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: Stoeppel cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] problems with CAST :-{ In-Reply-To: <000801bd8f27$42de3fc0$0a0aa8c0@aldi> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 3 Jun 1998, Stoeppel wrote: > Hi all > > I hate it. Everytime i use want to use CAST i get > -- parse error at or "(" -- !!! > This is the only message I get. I've tried EVERY combination of types and > syntaxes. > > Maybe there ist something wrong in the installation or the environment or i > am simple stupid `:-( > > I use Postgres 6.2 under SUSE LINUX 5.1 Maybe a syntax error ? The old syntax was: CAST expr AS type then new one (SQL92) is: CAST(expr AS type) Jose'