[SQL] How to select text field as interger

[Jerrel Kemper]

Dear members,


My table consist off the following fields


CREATE TABLE test
(
  id bigserial NOT NULL,
  name character varying(100),
   CONSTRAINT logs_pkey PRIMARY KEY (log_id)
)


with value :

ID    Name
1      001
2        01
3          1
4        11

Select name from test where name = '1' ;

results in :

Name
  1


If the 'Name' field was define as a serial the result set ought to be

Name
  001
    01
      1


Question?

How can I have the same result set as above

Name
  001
    01
      1


with the name field defined as character varying.



Thanks

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql