[prev in list] [next in list] [prev in thread] [next in thread] 

List:       velocity-user
Subject:    Re: Velocity newbie (OT)
From:       Fergus Gallagher <Fergus.Gallagher () OrbisUK ! com>
Date:       2001-09-25 9:44:48
[Download RAW message or body]

Indeed!

	alter table myTable add constraint 
		( primary key(key1,key2) constraint myTable_pk);

but syntax differs between RDBMS vendors.

F

On Mon, Sep 24, 2001 at 11:08:29AM -0700, Jon Stevens wrote:
> on 9/24/01 11:01 AM, "Will Glass-Husain" <wglass@forio.com> wrote:
> 
> > Technically, concatenating keys doesn't ensure uniqueness.
> > 
> > Key 1 = "123"
> > Key 2 = "1"
> > Concatenated key = "1231"
> > 
> > or
> > 
> > Key 1 = "12"
> > Key 2 = "31"
> > Concatenated key = "1231"
> > 
> > However, (Practically speaking) this is probably a rare case.
> > 
> > WILL
> 
> I *knew* someone would think this.
> 
> I didn't mean String concatenation.
> 
> -jon

-- 
Fergus Gallagher          Tel: +44 (20) 8742 1600
Orbis                     Fax: +44 (20) 8742 2649
414 Chiswick High Street  email: Fergus.Gallagher@orbisuk.com
London  W4 5TL            Web: http://www.orbisuk.com

[prev in list] [next in list] [prev in thread] [next in thread]