Thread

1. problems with CAST :-{

   Stoeppel <stoeppel@oberland.net> — 1998-06-03T19:39:00Z

   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
   
   Please, please help me ?
   
   Greetings from Bavaria
   
   --
   Robert Stoeppel   -->http://www.stoeppel.de <---
   Buchhandlung Stoeppel - Stoeppel Verlag
   Bertelsmann Club
   Tel.: 0881/9224-0
   Fax: 0881/ 2554
   
    -----------------------------------------------------------------------
    -> Robert Stoeppel
    -> http://www.stoeppel.de
    -> Buchhandlung  - Verlag - Bertelsmann Club Filiale
    -> Tel.: 0881/9224-0
    -> Fax.: 0881/2554 
   
   
   

2. Re: [SQL] problems with CAST :-{

   jose' soares <sferac@bo.nettuno.it> — 1998-06-04T10:30:59Z

   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'
   
   
   

3. Re: [SQL] problems with CAST :-{

   Herouth Maoz <herouth@oumail.openu.ac.il> — 1998-06-07T08:13:29Z

   At 22:39 +0300 on 3/6/98, Stoeppel wrote:
   
   
   > 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
   >
   > Please, please help me ?
   
   CAST has only been introduced in 6.3, so you don't have it in 6.2.
   
   Herouth
   
   --
   Herouth Maoz, Internet developer.
   Open University of Israel - Telem project
   http://telem.openu.ac.il/~herutma
   
   
   
   

4. Re: [SQL] problems with CAST :-{

   Marin D <marin@iclub.cybernet.bg> — 1998-06-07T13:05:54Z

   
   On Sun, 7 Jun 1998, Herouth Maoz wrote:
   
   > 
   > CAST has only been introduced in 6.3, so you don't have it in 6.2.
   >  
   
   This is from the HISTORY file of the distribution
   
   [snip]
   
   Postgres95 1.01              Fri Feb 23 18:20:36 PST 1996
   =========================================================
   
   Enhancements:
   
    * added CAST .. AS ... syntax
   
   [snip]
   
   
   Any comments?
   
   	
   	Marin
   
   
             -= Why do we need gates in a world without fences? =-
   
   
   
   

5. Re: [SQL] problems with CAST :-{

   jose' soares <sferac@bo.nettuno.it> — 1998-06-08T12:00:12Z

   On Sun, 7 Jun 1998, Herouth Maoz wrote:
   
   > At 22:39 +0300 on 3/6/98, Stoeppel wrote:
   > 
   > 
   > > 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
   > >
   > > Please, please help me ?
   > 
   > CAST has only been introduced in 6.3, so you don't have it in 6.2.
   > 
   Sorry Hearouth but you are wrong.
   CAST is there from v1.01.
   Only syntax was different.
                                                      Jose'