--- Bruno Wolff III <bruno@wolff.to> wrote:
> On Tue, Apr 11, 2006 at 14:01:08 -0700,
> operationsengineer1@yahoo.com wrote:
> > like so?
> >
> > t_translations
> > language_id (used for table level pkey)
> > base_text_id (used for table level pkey)
> > translation (text)
> >
> > i haven't worked with table level pkeys before.
> next
> > time i get pgadmin3 fired up, i'll look into it.
>
> Here is an example of a table constraint right from
> the documentation:
> CREATE TABLE films (
> code char(5),
> title varchar(40),
> did integer,
> date_prod date,
> kind varchar(10),
> len interval hour to minute,
> CONSTRAINT code_title PRIMARY KEY(code,title)
> );
>
cool beans! but my mysql friends tell me pgsql is
slow... is it?
juuuuuust kidding!
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com