Isolating a record column from a PL-Pgsql function call ?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Isolating a record column from a PL-Pgsql function call ?
Date: 2008-12-16 17:24:42
Message-ID: 482E80323A35A54498B8B70FF2B8798003E58E4B01@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

I have a PL-Pgsql function that returns a record of a type that have 4 elements (columns). Let's say the first element/column is called "id_num". Is there a way I can specify the id_num element of the record returned from iside a query?

For example, select col1 from thetable where my_plpgsql_fn(col2).id_num = 123;

(my_plpgsql_fn is the function call, id_num is the columns I want returned).

Thanks
-dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message TJ O'Donnell 2008-12-16 17:48:16 Re: Lost password
Previous Message Ketema Harris 2008-12-16 17:07:51 Re: View vs Constantly Updated Table