Re: Postgresql function which compares values from both tables

From: "David Johnston" <polobo(at)yahoo(dot)com>
To: "'Rehan Saleem'" <pk_rehan(at)yahoo(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Postgresql function which compares values from both tables
Date: 2012-03-19 20:04:04
Message-ID: 00b101cd060b$6f87a560$4e96f020$@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2012-03-19 20:59:23 Re: Postgresql function which compares values from both tables
Previous Message Rehan Saleem 2012-03-19 19:40:06 Postgresql function which compares values from both tables