I've created a view 'principals' that gives me this output:
pgslekt= select * from principals where event=15821;
person | event | place | sort_date | tag_type
+---+---++--
2 | 15821 | 1152 | 1999-09-17 |4
3 | 15821 | 1152 | 1999-09-17 |
SELECT * FROM principals WHERE event = 15821 AND person != 2?
Dmitri
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Leif B.
Kristensen
Sent: Thursday, September 22, 2005 1:30 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Help with a view
On Thursday 22 September 2005 20:03, Dmitri Bichko wrote:
SELECT * FROM principals WHERE event = 15821 AND person != 2?
Sure, that's a concise answer to what I actually wrote, but it wasn't
exactly what I intended :)
Basically, what I've got is the first person and the tag_type. I can do
it
Basically, what I've got is the first person and the tag_type. I can do
it with a function from PHP:
function get_spouses($p) {
$handle = pg_query(select person from principals
where event in (select event from principals
where person = $p
@postgresql.org
Subject: Re: [SQL] Help with a view
On Thursday 22 September 2005 20:03, Dmitri Bichko wrote:
SELECT * FROM principals WHERE event = 15821 AND person != 2?
Sure, that's a concise answer to what I actually wrote, but it wasn't
exactly what I intended :)
Basically