Seeking simple after insert example - comp.databases.ibm-db2

Message from discussion Seeking simple after insert example

Dave Hughes

More options May 16, 11:47 pm

Newsgroups: comp.databases.ibm-db2

From: "Dave Hughes" <d...@waveform.plus.com>

Date: Fri, 16 May 2008 22:47:01 -0500

Local: Fri, May 16 2008 11:47 pm

Subject: Re: Seeking simple after insert example

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

gimme_this_gimme_t...@yahoo.com wrote:
> I'm using DB2 8.1.

> Suppose table foo has columns name and lname:

> create table foo
> (name as varchar(200),
> lname as varchar(200));

> Write a trigger that inserts the lower case value of name after an
> insert:

> So

> insert (name) into foo values ('Hello World");

> Then:

> select * from foo;

> Results in:

> "Hello World","hello world"

> Thanks

Any particular reason you don't want to use a generated column?

CREATE TABLE FOO (
NAME VARCHAR(200),
LNAME VARCHAR(200) GENERATED ALWAYS AS (LOWER(NAME))
);

Cheers,

Dave.

Reply to author Forward