<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
I am trying to develop a trigger function that searches for lines with particular properties. I have two or more lines joining at a point but only one line exiting from that point. I want to check that the size of the outgoing (exiting) line is always not smaller than incoming lines.<br>Take such data as example:<br>line_name from_point to_point size<br>line1 p1 p2 2<br>line2 p10 p2 3<br>line3 p2 p7 1<br>line4 p7 p8 3<br><br>Lines Line1 and Line2 join at point p2 (to_point), therefore line3 should have size at least equal to 3.<br>Tried to use this select statement but doesnt work, could anyone give me an idea<br>Select link_name, diameter, from_node, to_node from links as ends where ends.diameter< links.diameter;<br>or even<br>SELECT from_node from links as dstream intersect SELECT to_node from links as previo ;<br><br>Thank you<br><br>Broun Uganda<br><br /><hr />Discover the new Windows Vista <a href='http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE' target='_new'>Learn more!</a></body>
</html>