Re: Postgresql function which compares values from both tables

<font face="sans-serif" size="2">Hi,</font><br /><font face="sans-serif" size="2">> To: pgsql-sql@postgresql.org<br
/>> Subject: [SQL] Postgresql function which compares values from both tables</font><br /><font face="sans-serif"
size="2">> </font><br /><font face="sans-serif" size="2">> hi ,<br /> > how to write a function which should
readdata from 2 tables having <br /> > same number of columns and should show the common values from those
tables.<br/> If you want to compare and ensure that the values are same for <b>all</b> columns, please have a look at
INTERSECT</font><br/><a href="http://www.postgresql.org/docs/9.1/static/sql-select.html"><font face="sans-serif"
size="2">http://www.postgresql.org/docs/9.1/static/sql-select.html</font></a><br/><font face="sans-serif"
size="2">Regards,</font><br/><font face="sans-serif" size="2">Jayadevan<br /></font><br /><font face="sans-serif"
size="2"><br/><br /><br /><br /> DISCLAIMER:</font><font size="3"> </font><font color="#a2a2a2" face="Tahoma"
size="1"><br/><br /> "The information in this e-mail and any attachment is intended only for the person to whom it is
addressedand may contain confidential and/or privileged material. If you have received this e-mail in error, kindly
contactthe sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor
guaranteesthe accuracy, adequacy or completeness of the information contained in this email or any attachment and is
notliable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or
indirect."</font><fontsize="3"><br /></font><font size="1"><br /></font><font size="3"><br /></font><br /><br />