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(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
On Behalf Of Rehan Saleem
Sent: Monday, March 19, 2012 3:40 PM
To: pgsql-sql(at)postgresql(dot)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