Re: Default Value in Table Setup Help

On Mon, 18 Aug 2003, Dev wrote:

> Hello all,
>
> I am working on setting up a table that will append a sequence to the end
> of the value inserted.
> Example;
> INSERT INTO test (test) VALUES ('abcd');
> And have the data in the database be;
> abcd0001
>
> Now I do have things setup else where were the default value for the field
> is such:
> default ('abcd'::text || lpad(text(nextval('test_sequence'::text)), 4,
> '0'::text))
>
> But i want the "abcd" or what erver to be added in the insert?
>
> What am I missing to make this happen?

You don't want to use a default (since that'll be ignored if you actually
pass in a value for the column). You probably want a before trigger that
alters the value that was inserted before the insertion actually happens.