Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql function which compares values from both tables - Mailing list pgsql-sql

From David Johnston
Subject Re: Postgresql function which compares values from both tables
Date
Msg-id 00b101cd060b$6f87a560$4e96f020$@yahoo.com
Whole thread Raw
In response to Postgresql function which compares values from both tables  (Rehan Saleem <pk_rehan@yahoo.com>)
Responses Re: Postgresql function which compares values from both tables  (Richard Huxton <dev@archonet.com>)
Re: Postgresql function which compares values from both tables  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
List pgsql-sql
Tree view

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

pgsql-sql by date:

Previous
From: Rehan Saleem
Date:
Subject: Postgresql function which compares values from both tables
Next
From: Richard Huxton
Date:
Subject: Re: Postgresql function which compares values from both tables