pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Borek Lupoměský <borekl@volny.cz>
Cc: Francis Solomon <francis@stellison.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL parse error
Date: Tue, 12 Dec 2000 16:17:04 -0500
Message-ID: <3453.976655824@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.21.0012121138090.26258-100000@diaspar.ujep.cz>
References: <Pine.LNX.4.21.0012121138090.26258-100000@diaspar.ujep.cz>

=?ISO-8859-2?Q?Borek_Lupom=ECsk=FD?= <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



view thread (9+ messages)  latest in thread

Message-ID: <3453.976655824@sss.pgh.pa.us>
Permalink:  ../3453.976655824@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3453.976655824@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, borekl@volny.cz, francis@stellison.co.uk
  Subject: Re: SQL parse error
  In-Reply-To: <3453.976655824@sss.pgh.pa.us>
  References: <Pine.LNX.4.21.0012121138090.26258-100000@diaspar.ujep.cz> <3453.976655824@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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