Postgres Pro
Downloads
Home   >   mailing lists

Thread: problems with CAST :-{

problems with CAST :-{

From
Stoeppel@oberland.net (Stoeppel)
Date:
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

Re: [SQL] problems with CAST :-{

From
"Jose' Soares Da Silva"
Date:
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'

Re: [SQL] problems with CAST :-{

From
Herouth Maoz
Date:
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

Re: [SQL] problems with CAST :-{

From
Marin D
Date:

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? =-

Re: [SQL] problems with CAST :-{

From
"Jose' Soares Da Silva"
Date:
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'