multiple foreign keys for a row

From: message <letter(at)openmailbox(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: multiple foreign keys for a row
Date: 2017-06-06 19:21:42
Message-ID: 0a87c59aa008783b036201795420574f@openmailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Readers,

Scenario:
table1
headercolumn1 headercolumn2 headercolumn3
1 texta textb textc 200.987

table2
texta
textb
textc

The requirement is that 'texta' 'textb' 'textc' (either any combination
or all) appear in the column labelled 'headercolumn2'.

How to amend the standard instruction to use foreign keys (manual
§5.3.5) to refer to table2?

Browse pgsql-novice by date

  From Date Subject
Next Message armand pirvu 2017-06-06 19:32:28 Re: beginner help
Previous Message Mark Plimley 2017-06-06 18:34:16 beginner help