create table with default value... - Mailing list pgsql-sql

Hi,

I have a table with a Unique ID named U_ID that come from a sequence like 
that :

create table the_table( U_ID integer default NEXTVAL('THE_SEQUENCE'), ...

and I would like to have a field of type varchar that would be something 
like

create table the_table( U_ID integer default NEXTVAL('THE_SEQUENCE'), name varchar(50) default 'NT_'+itoa(U_ID)
);

so the field 'name' would be the string concatenation of "NT_" and the 
string value of the field U_ID.

Is there a way to do this?

Thanks for your precious help!  ;)

\fb

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com