pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems 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