From: | "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | lockhart(at)alumni(dot)caltech(dot)edu, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] money or dollar type |
Date: | 1998-05-13 09:55:01 |
Message-ID: | Pine.LNX.3.96.980513094736.474B-100000@proxy.bazzanese.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 12 May 1998, Bruce Momjian wrote:
> > prova=> select var as my_varchar from prova where var = '12';
> > my_varchar
> > ----------
> > 12 <--right justified
> > (1 row)
> >
> > prova=> select var as my_varchar from prova;
> > my_varchar
> > ----------
> > 12 <--left justified, this time ???
> > a12
> > a12
> > (3 rows)
> > Jose'
>
> I can't reproduce this here.
Seems that PostgreSQL justify data based on data not on data type.
My environment is:
PostgreSQL v6.3
Linux 2.0.33
also Daniel A. Gauthier <3in7ifi(at)cmich(dot)edu>
reported the same problem.
here my script:
create table prova ( my_varchar varchar );
CREATE
insert into prova values ('12');
INSERT 528521 1
insert into prova values ('a12');
INSERT 528522 1
select * from prova where my_varchar = '12';
my_varchar
----------
12
(1 row)
select * from prova;
my_varchar
----------
12
a12
(2 rows)
EOF
Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares Da Silva | 1998-05-13 10:13:20 | Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name' |
Previous Message | Mikhail Routchiev | 1998-05-13 09:46:21 | One problem with Postgres... |