Horton

Re: Postgresql function which compares values from both tables

David Johnston <polobo@yahoo.com>

View thread View on postgr.es
From: "David Johnston" <polobo@yahoo.com>
To: "'Rehan Saleem'" <pk_rehan@yahoo.com>, <pgsql-sql@postgresql.org>
Date: 2012-03-19T20:04:04Z
Lists: pgsql-sql 
You would need to install the "HSTORE" extension to convert the record into
a key->value pair then perform the comparison on that.

 

Dave

 

 

From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Rehan Saleem
Sent: Monday, March 19, 2012 3:40 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Postgresql function which compares values from both tables

 

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