| From: | Alessandro Rossi <alex(at)sunrise(dot)radiostudiodelta(dot)it> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | RETURN VALUES ON INTEGERS |
| Date: | 1999-07-07 12:20:56 |
| Message-ID: | Pine.LNX.4.05.9907071406260.12067-100000@sunrise.radiostudiodelta.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alessandro Rossi | 1999-07-07 12:24:16 | RETURN VALUES ON INTEGERS |
| Previous Message | Herouth Maoz | 1999-07-07 11:57:09 | Re: [SQL] Type Conversion: int4 -> Money |