RETURN VALUES ON INTEGERS - Mailing list pgsql-sql

From Alessandro Rossi
Subject RETURN VALUES ON INTEGERS
Date
Msg-id Pine.LNX.4.05.9907071406260.12067-100000@sunrise.radiostudiodelta.it
Whole thread Raw
List pgsql-sql
I have the following DATABASE.

CREATE TABLE codestatus    (id                int primary key,code                int,status                char
);

code is an int number made at least of 6 numbers.
(range from 0 up to 999999)

If i do :

select * from codestatus;

I GET:

id|code|status
--+------+------1| 44111|N    2|   123|S

BUT I WOULD LIKE TO GET

id|code|status
--+------+------1|044111|N    2|000123|S

How could I fix the prbolem and get the values as I ned them out of the
select ?

thanks in advance

Alex




pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [SQL] Type Conversion: int4 -> Money
Next
From: Alessandro Rossi
Date:
Subject: RETURN VALUES ON INTEGERS