On Wed, 13 Dec 2000, Tom Lane wrote:
TL> =?ISO-8859-2?Q?Borek_Lupom=ECsk=FD?= <[EMAIL PROTECTED]> writes:
TL> >When I do this, it works for me, too. But when I do it on my current
TL> > database, something breaks.
TL>
TL> Hm. The obvious question is: are you *sure* all the entries in your
T
=?ISO-8859-2?Q?Borek_Lupom=ECsk=FD?= <[EMAIL PROTECTED]> writes:
>When I do this, it works for me, too. But when I do it on my current
> database, something breaks.
Hm. The obvious question is: are you *sure* all the entries in your
table look like ".N"?
regards,
On Tue, 12 Dec 2000, Tom Lane wrote:
TL> play=> create table out2cp(cp varchar(6));
TL> CREATE
TL> play=> insert into out2cp values('3182.1');
TL> INSERT 405833 1
TL> play=> insert into out2cp values('3182.2');
TL> INSERT 405834 1
TL> play=> select substring(cp from 1 for 4)::int4 from out2cp;
TL
On Tue, 12 Dec 2000, Tom Lane wrote:
TL> I can't duplicate the problem either. I tried:
TL>
TL> play=> select substring(cp from 1 for 4)::int4 from out2cp;
TL> ?column?
TL> --
TL> 3182
TL> 3182
TL> (2 rows)
TL>
TL> Does anyone else see a failure with this? If so what platfo
=?ISO-8859-2?Q?Borek_Lupom=ECsk=FD?= <[EMAIL PROTECTED]> 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
> postgresq
All-
While it is not always the case, I see many responses to questions in the form of "Why
don't you just upgrade- that's supported in version XXX".
Let me give you several reasons why this is not always possible.
1. Support software is not compatible.
I use Chili!soft for Linux, a webpag
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
Bye Borek
--
==
Hi Borek,
What version of PostgreSQL are you using? This works fine for me on
7.02. Time to update, maybe?
Hope this helps
Francis
>
>Hello all,
>
>My following problem is:
>
> swports=# select substring(cp from 1 for 4)::int4 from out2cp;
> ERROR: pg_atoi: error in "6.1,": can't pars
Hello all,
My following problem is:
swports=# select substring(cp from 1 for 4)::int4 from out2cp;
ERROR: pg_atoi: error in "6.1,": can't parse ".1,"
SQL syntax is apparently OK. When I omit the typecast, the query
works:
swports=# select substring(cp from 1 for 4) from out2cp;
subs
