Skip site navigation (1) Skip section navigation (2)

optional reference

From: bill house <wchouse(at)bellsouth(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: optional reference
Date: 2010-01-24 02:14:05
Message-ID: 4B5BACED.4020208@bellsouth.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

What is a technique to reference some (but not all) rows from table a to 
a row in table b?

For example:

---------------------------

DROP TABLE a;
DROP TABLE b;


CREATE TABLE a (
   column_1 character(8),
   column_2 character(2),
   column_3 character(40)
   );

INSERT INTO a VALUES
   ('20901234', '01', 'This is a the first row'),
   ('20901234', '01', 'This is the second row'),
   ('20901234', '01', 'This is the third row'),
   ('20901235', '01', 'This is the fourth row'),
   ('20901236', '01', 'This is the fifth row'),
   ('20901236', '01', 'This is the sixth row'),
   ('20901237', '01', 'This is the seventh row'),
   ('20901238', '01', 'This is the eighth row');

CREATE TABLE b (
   column_1 character(8),
   column_2 character(2),
   column_3 character(40),
   PRIMARY KEY (column_1, column_2)
   );

  INSERT INTO b VALUES
   ('20901234', '01', 'Footnote #1'),
   ('20901234', '02', 'other stuff'),
   ('20901237', '01', 'Footnote #2');

--------------------------------------

Table a rows 1, 2 & 3 should point to table b row 1.

Table a row 7 should point to table b row 3.

Any guidance would be appreciated.

Thanks,

Bill House




Responses

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2010-01-24 07:45:38
Subject: Re: 8.5 beta manual
Previous:From: Tom LaneDate: 2010-01-23 19:45:21
Subject: Re: 8.5 beta manual

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group