Re: Alias "all fields"? - Mailing list pgsql-general

From Franz.Rasper@izb.de
Subject Re: Alias "all fields"?
Date
Msg-id 11EC9A592C31034C88965C87AF18C2A702B83685@m0000s61
Whole thread Raw
In response to Alias "all fields"?  (Franz.Rasper@izb.de)
Responses Re: Alias "all fields"?
Re: Alias "all fields"?
List pgsql-general
> Make the table:

> id | year | value
> ---+------+------
> 1  | 1970 |    23
> 1  | 1971 |    25
> 1  | 1972 |    28
>  ...
> 2  | 1972 |     5
> 3  | 1971 |    94
> 3  | 1972 |   102

> primary key: (id,year)
> value not null
> and be ready.
>the import/update reasons are pretty easily solved
>that way too.

then your primary key  will consists of two fields.
I prefer the primary keys with one field only.

-Franz


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL with Kerberos and Active Directory
Next
From: Tom Lane
Date:
Subject: Re: Alias "all fields"?