Re: Primary key question

key question Hi, thanks for the tip, but I never need to query the traffic_data_types and integration_periods for a single message_source, so I will keep the double bracket notation then for now. Thanks, Wim 2014-07-01 12:03 GMT+02:00 Jens Rantil : Hi again, As a follow-up; if you

Re: Primary key question

Hi, thanks for the tip, but I never need to query the traffic_data_types and integration_periods for a single message_source, so I will keep the double bracket notation then for now. Thanks, Wim 2014-07-01 12:03 GMT+02:00 Jens Rantil : > Hi again, > > As a follow-up; if you have many `message

Re: Primary key question

Hi again, As a follow-up; if you have many `message_source_id`s you could also do: CREATE TABLE integration_time ( message_source_id uuid, traffic_data_type varchar, integration_period varchar, integration_time timestamp, PRIMARY KEY (message_source_id,traffic_data_type,integration_period) ); Th

Re: Primary key question

Hi Wim, Yes, that is looks correct to me. Cheers, Jens On Tue, Jul 1, 2014 at 8:37 AM, Wim Deblauwe wrote: > Hi, > > I have the following table: > > CREATE TABLE integration_time ( > message_source_id uuid, > traffic_data_type varchar, > integration_period varchar, > integration_time timestam

Primary key question

Hi, I have the following table: CREATE TABLE integration_time ( message_source_id uuid, traffic_data_type varchar, integration_period varchar, integration_time timestamp, PRIMARY KEY ((message_source_id,traffic_data_type,integration_period)) ); I want the combination of (message_source_id, traff