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