Re: SQL parse error - Mailing list pgsql-sql

From Tom Lane
Subject Re: SQL parse error
Date
Msg-id 3453.976655824@sss.pgh.pa.us
Whole thread Raw
In response to RE: SQL parse error  (Borek Lupoměský <borekl@volny.cz>)
Responses Re: SQL parse error
List pgsql-sql
Borek Lupoměský <borekl@volny.cz> writes:
> On Tue, 12 Dec 2000, Francis Solomon wrote:
FS> What version of PostgreSQL are you using? This works fine for me on
FS> 7.02. Time to update, maybe?

>    Does not seem to be the case...

> ld01ad02:~$ rpm -q postgresql
> postgresql-7.0.2-2

I can't duplicate the problem either.  I tried:

play=> create table out2cp(cp varchar(6));
CREATE
play=> insert into out2cp values('3182.1');
INSERT 405833 1
play=> insert into out2cp values('3182.2');
INSERT 405834 1
play=> select substring(cp from 1 for 4)::int4 from out2cp;?column?
----------    3182    3182
(2 rows)

Does anyone else see a failure with this?  If so what platform are you
on, and what build of Postgres are you using?
        regards, tom lane


pgsql-sql by date:

Previous
From: Borek Lupoměský
Date:
Subject: Re: SQL parse error
Next
From: Luca Pregliasco
Date:
Subject: Re: Persistent Connects (pg_pconnect)