Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id A99EBC7DB13
	for <pgsql-sql@postgresql.org>; Mon, 19 Mar 2012 16:40:20 -0300 (ADT)
Received: from nm12-vm2.bullet.mail.ne1.yahoo.com ([98.138.91.88])
	by makus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <pk_rehan@yahoo.com>) id 1S9iRH-0006OH-5S
	for pgsql-sql@postgresql.org; Mon, 19 Mar 2012 19:40:19 +0000
Received: from [98.138.90.50] by nm12.bullet.mail.ne1.yahoo.com with NNFMP;
	19 Mar 2012 19:40:06 -0000
Received: from [98.138.89.172] by tm3.bullet.mail.ne1.yahoo.com with NNFMP;
	19 Mar 2012 19:40:06 -0000
Received: from [127.0.0.1] by omp1028.mail.ne1.yahoo.com with NNFMP;
	19 Mar 2012 19:40:06 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 717143.37210.bm@omp1028.mail.ne1.yahoo.com
Received: (qmail 50117 invoked by uid 60001); 19 Mar 2012 19:40:06 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1332186006; bh=vq86q6v7fbmMTGgUFazNjqwZkuhvZRPdLFwRtq7slho=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=3uR0jegZ3rTBb9Q9Z74re9g6FkIK5bZ6hyOVviyJeQZ58IwrWVwTQMU1PGz0jiv1wk9P9bHKoNvyEy3mPlC1NJ8jiH6hstLPlH2ZNV8bOPM0WHHe93sSoPheIIydfayw6kaEI6V6CKW2tNGz2p2/ykyK40ZxvaI/3qpuZMbrHzM=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=ioim7V9VaYoRA4dot0MsWRmdAR2dDlb8S1PcAAlVBy2WuW3AqXsKot9pLPXoGSAfQ3hy4+ASX+SBd+s5G1L9AHljaMGSH0cPAClkCG6a+zowdbyAeBs76j6E499Q7LWDV4HiAb7VvsZERyQM5uK2igEMHjReGT4KEhagyXA9+ps=;
X-YMail-OSG: LwzI8D0VM1kGmn.FZXg_eQIeBN5N0rnVJYoQS5PuTiPT_Am
	CjcQbxk7nYAx6zkUvNHZn6vAahufv4geLnfRL1mzp3uBD97_9RNkWMmWVrDN
	sUlrTacbn3xoI5_DK.gGCR8aAsrro9Z3mh2A0Z4I2BJrudeHvPtME.qYIwy3
	e.Sjf4FZA_sxr81NG9xzLUw92f302vrX6moHShdO.YWtZtj4GSDEhmGTTdEg
	FVUIn2R9l8LMq1mCj7DSUmyGEbcnvkQqd39C3niGhVOF9Fd4WleF409vC_DK
	D9ZsHPfC8C2p9u48h5agTS9cS6c9JXp4nm8nxgv1LrAmzMOtVV25lU0YGHin
	.y1n.lhVwmjCYKhCsPhvCSBBlin7J9qguX2vDTuO9xo847LHkUtyBZqdt1Rc
	uuSnxR_g1QwIWIn9p4hAAxFGzUMzPaZJdEzADh2Baj1XAB1f9Vto9ftAGXzV Xo5s-
Received: from [182.177.147.66] by web121605.mail.ne1.yahoo.com via HTTP;
	Mon, 19 Mar 2012 12:40:06 PDT
X-Mailer: YahooMailWebService/0.8.116.338427
Message-ID: <1332186006.44650.YahooMailNeo@web121605.mail.ne1.yahoo.com>
Date: Mon, 19 Mar 2012 12:40:06 -0700 (PDT)
From: Rehan Saleem <pk_rehan@yahoo.com>
Reply-To: Rehan Saleem <pk_rehan@yahoo.com>
Subject: Postgresql function which compares values from both tables
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="2053635335-1467089104-1332186006=:44650"
X-Pg-Spam-Score: 1.6 (+)
X-Archive-Number: 201203/48
X-Sequence-Number: 36443

--2053635335-1467089104-1332186006=:44650
Content-Type: text/plain; charset=us-ascii

hi ,
how to write a function which should read data from 2 tables having same number of columns and should show the common values from those tables.
thanks

--2053635335-1467089104-1332186006=:44650
Content-Type: text/html; charset=us-ascii

<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">hi ,<br>how to write a function which should read data from 2 tables having same number of columns and should show the common values from those tables.<br>thanks<br></div></body></html>
--2053635335-1467089104-1332186006=:44650--