From: "Ray Madigan" <ray@madigans.org>
To: <pgsql-sql@postgresql.org>
Subject: Trigger on select :-(
Date: Mon, 1 Mar 2010 18:10:47 -0800
Message-ID: <CMEFJOLLJJDJKKLGEJJMOELBDDAA.ray@madigans.org>
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_NextPart_000_00B2_01CAB96A.84518F50"
Importance: Normal

This is a multi-part message in MIME format.

------=_NextPart_000_00B2_01CAB96A.84518F50
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

What I want is to have a trigger on select, but since I have searched the
archives I know that is not possible.  I also read that view rules is the
technology is whats available.  Having never used views before I can't seem
to get my mind to figure out what I need to do to solve my problem.

I have a table that defines a key that I will use in another table in a list
of items defined in the previous table.

The tables are

CREATE TABLE Foo ( INTEGER key not null primary key,
                                  ...  characteristics for the Foo item );

CREATE TABLE Catalog ( INTEGER FooKey FOREIGN KEY,
                                        ... other catalog data );

The catalog will have rows that reference the elements in the Foo table.

I also have another table that references the Foo table

CREATE TABLE ToDo ( INTEGER FooKey FOREIGN KEY,
                                    ... other ToDo information.

What I want to do is when I do a SELECT on the Catalog and deliver the
result to the user, I want to check to see if the FooKey is in the users
ToDo table and set the value of a column isToDo to true or false depending
on if the FooKey exists in the ToDo table for the user.  If I were building
a table I would use a trigger and select on the row in the ToDo table.

Please, all I want is an idea where to start, what I should read and I will
figure out how to do it.

Thanks in advance.

------=_NextPart_000_00B2_01CAB96A.84518F50
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+Ii8CAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANoHAwABABIACgAAAAEAAgEB
A5AGADAIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAFgAAAFRyaWdnZXIgb24gc2VsZWN0IDotKAAAAAIBcQABAAAAFgAAAAHKua2P23qVuLTOQEU7
orlKpOPx1BoAAAIBHQwBAAAAFgAAAFNNVFA6UkFZQE1BRElHQU5TLk9SRwAAAAsAAQ4AAAAAQAAG
DgCMYHatucoBAgEKDgEAAAAYAAAAAAAAANL8SwAJwyxFnrtLxeG2QF/CgAAACwAfDgEAAAACAQkQ
AQAAAMUDAADBAwAAaAYAAExaRnU2cLQEAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj
aArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYM5jAFALAwu1IFcQ8AVAOEkgdwBwBUAEACB0hG8g
EPB2ZSBhFLCpBRBnZwSQIAIgIBEggmwFkHQsIGJ1BUD5AJBuYxUgFCAU8xEgCsC/EOAJgBSwF/AV
MBfRaRUQ4wQgFCBrbm8H4BgwE/GnFJEZMAVAcG8EEGkCYNhlLiAUEQdAcxTQCXDeYRgSE/ESIhtA
dRYwBCBrFJIYQXQFkGgZMAkAZ/p5FIJ3E+EEIBUAC3ALYK0ahEgVAAuAZxngZRUQvQXAdREgGBAS
IgQgYgEQawWwFxJjAHAnFrEJ4G3XFLIVoAVAbR2gbRJxFLL+ZhWACHAVIAhgBUAd8hQRdx+AGAIU
0GQU0BTBGyBsmxURIkFwA2AagW0uCqL/CoQKgBc1FUEeohlkAQELgPMHkRVAa2UdoBlzFCEDEP8D
IB/hFIADoABwGgAX8AXAMydUKeIgbAQABUBvZvsUgB0QbQQgKAQYECnhGDJ7JYAfkGkIYBShHqMm
ClQfHOIeoh4xCXAmCkNSRQBBVEUgVEFCTKkwsEZvFNAoFBBOMKDYR0VSKJMZ8m4cUAMg3yWAB3AK
wB2gKKEsJgQawPs0HzUdLjYgGsAQ4gDQHRD/BRArYA3gBCAgsRgjMTIrwtggKTsvrzC2QxPwB0CX
HYAxaTExSyixRk8wcIBJR04gS0VZM5/fPX81Xyo0ISA6VGQ6QTh9/y7CQAYpUxTzA2AgYRlzCXD+
ZgSQCfAXARgyFiEHgAIw/xyBLLQxMi2vJrEbAxT0KisfQ2wctEWXOK8wtlRvRP8xWjtfPG9O/z7P
FbFL8wuA/yCxAMA3IAIgJfsT2iRkHcNPCfAUESSRFUBTRTEAQ/5UFdIYMjo2AHAYEAEAK0D3H6IY
MglwcxxQU8MYMh/hznIWcFN4F+FjaySzCeD/FIAroDe1TRIUkSylWHIEIP9L8ydUVpIRIRgjHmAK
QSuC8xVACOF1bQOgBABcJCShdxxAI0EFwGYbARUgAQBwnQnwZB9CFeFaTGV4K1H/RQdcKTd2WHIa
siugFCFD4f8WgQMQYIMnNhQhCGBlMCmTfxVIXNQWMlWWQxFiTy3sUP0WMGERIBZwB0ADIBQoA5H+
aQEAFUBUcSDRJMIBkAAg8xZwI6VzaGZDG1NWkik1byL5bhAZUVP0dC39AHBrv0UDG3AeYBbxJfUR
4QBzcAAAAAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAQgAggBgAAAAAAwAAAAAAA
AEYAAAAAUoUAACdqAQAeABKACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA5LjAAHgAT
gAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AFIAIIAYAAAAAAMAAAAAAAABG
AAAAADeFAAABAAAAAQAAAAAAAAAeABWACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAA
AAAACwAWgAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALAEOACCAGAAAAAADAAAAAAAAARgAA
AAAOhQAAAAAAAAMARYAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwBGgAggBgAAAAAAwAAA
AAAAAEYAAAAAEYUAAAAAAAADAEeACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAAMAXYAIIAYA
AAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwCCgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAAC
AfgPAQAAABAAAADS/EsACcMsRZ67S8XhtkBfAgH6DwEAAAAQAAAA0vxLAAnDLEWeu0vF4bZAXwIB
+w8BAAAAnQAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4
AQCqADfZbgAAAEM6XERvY3VtZW50cyBhbmQgU2V0dGluZ3NcUmF5IE1hZGlnYW5cTG9jYWwgU2V0
dGluZ3NcQXBwbGljYXRpb24gRGF0YVxNaWNyb3NvZnRcT3V0bG9va1xvdXRsb29rLnBzdAAAAAAD
AP4PBQAAAAMADTT9NwAAAgF/AAEAAAAwAAAAPENNRUZKT0xMSkpESktLTEdFSkpNT0VMQkREQUEu
cmF5QG1hZGlnYW5zLm9yZz4AAwAGENJGxLADAAcQ6wMAAAMAEBAAAAAAAwAREAEAAAAeAAgQAQAA
AGUAAABXSEFUSVdBTlRJU1RPSEFWRUFUUklHR0VST05TRUxFQ1QsQlVUU0lOQ0VJSEFWRVNFQVJD
SEVEVEhFQVJDSElWRVNJS05PV1RIQVRJU05PVFBPU1NJQkxFSUFMU09SRUFEVEhBAAAAACL2

------=_NextPart_000_00B2_01CAB96A.84518F50--