pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problems with CAST :-{
5+ messages / 4 participants
[nested] [flat]

* problems with CAST :-{
@ 1998-06-03 19:39 Stoeppel <Stoeppel@oberland.net>
  1998-06-04 10:30 ` Re: [SQL] problems with CAST :-{ Jose' Soares Da Silva <sferac@bo.nettuno.it>
  1998-06-07 08:13 ` Re: [SQL] problems with CAST :-{ Herouth Maoz <herouth@oumail.openu.ac.il>
  0 siblings, 2 replies; 5+ messages in thread

From: Stoeppel@oberland.net @ 1998-06-03 19:39 UTC (permalink / raw)
  To: pgsql-sql

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 




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] problems with CAST :-{
  1998-06-03 19:39 problems with CAST :-{ Stoeppel <Stoeppel@oberland.net>
@ 1998-06-04 10:30 ` Jose' Soares Da Silva <sferac@bo.nettuno.it>
  1 sibling, 0 replies; 5+ messages in thread

From: Jose' Soares Da Silva @ 1998-06-04 10:30 UTC (permalink / raw)
  To: Stoeppel <Stoeppel@oberland.net>; +Cc: pgsql-sql

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'




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] problems with CAST :-{
  1998-06-03 19:39 problems with CAST :-{ Stoeppel <Stoeppel@oberland.net>
@ 1998-06-07 08:13 ` Herouth Maoz <herouth@oumail.openu.ac.il>
  1998-06-07 13:05   ` Re: [SQL] problems with CAST :-{ Marin D <marin@iclub.cybernet.bg>
  1998-06-08 12:00   ` Re: [SQL] problems with CAST :-{ Jose' Soares Da Silva <sferac@bo.nettuno.it>
  1 sibling, 2 replies; 5+ messages in thread

From: Herouth Maoz @ 1998-06-07 08:13 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] problems with CAST :-{
  1998-06-03 19:39 problems with CAST :-{ Stoeppel <Stoeppel@oberland.net>
  1998-06-07 08:13 ` Re: [SQL] problems with CAST :-{ Herouth Maoz <herouth@oumail.openu.ac.il>
@ 1998-06-07 13:05   ` Marin D <marin@iclub.cybernet.bg>
  1 sibling, 0 replies; 5+ messages in thread

From: Marin D @ 1998-06-07 13:05 UTC (permalink / raw)
  To: Herouth Maoz <herouth@oumail.openu.ac.il>; +Cc: Stoeppel <Stoeppel@oberland.net>; pgsql-sql



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





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] problems with CAST :-{
  1998-06-03 19:39 problems with CAST :-{ Stoeppel <Stoeppel@oberland.net>
  1998-06-07 08:13 ` Re: [SQL] problems with CAST :-{ Herouth Maoz <herouth@oumail.openu.ac.il>
@ 1998-06-08 12:00   ` Jose' Soares Da Silva <sferac@bo.nettuno.it>
  1 sibling, 0 replies; 5+ messages in thread

From: Jose' Soares Da Silva @ 1998-06-08 12:00 UTC (permalink / raw)
  To: Herouth Maoz <herouth@oumail.openu.ac.il>; +Cc: Stoeppel <Stoeppel@oberland.net>; pgsql-sql

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'




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~1998-06-08 12:00 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-03 19:39 problems with CAST :-{ Stoeppel <Stoeppel@oberland.net>
1998-06-04 10:30 ` Jose' Soares Da Silva <sferac@bo.nettuno.it>
1998-06-07 08:13 ` Herouth Maoz <herouth@oumail.openu.ac.il>
1998-06-07 13:05   ` Marin D <marin@iclub.cybernet.bg>
1998-06-08 12:00   ` Jose' Soares Da Silva <sferac@bo.nettuno.it>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox