17, 2008 6:45 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Isolating a record column from a PL-Pgsql function call ?
On Tue, Dec 16, 2008 at 01:03:05PM -0700, Gauthier, Dave wrote:
The example I gave was overly simplistic. I actually want to look at
more than one of the columns
On Tue, Dec 16, 2008 at 01:03:05PM -0700, Gauthier, Dave wrote:
The example I gave was overly simplistic. I actually want to look at
more than one of the columns in the returned record, so rewritting it
to return an int won't address the need for the other columns. And
no, it does not return
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
Gauthier, Dave dave.gauth...@intel.com schrieb:
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
from a PL-Pgsql function call ?
Gauthier, Dave dave.gauth...@intel.com schrieb:
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
Gauthier, Dave dave.gauth...@intel.com schrieb:
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
Of Gauthier, Dave
Sent: Tuesday, December 16, 2008 3:03 PM
To: Andreas Kretschmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Isolating a record column from a PL-Pgsql function call ?
The example I gave was overly simplistic. I actually want to look at more than
one of the columns
Subject: RE: [GENERAL] Isolating a record column from a PL-Pgsql function call ?
And it's a bit more complicated at that. Here's why
I discovered that I can refer to the function as a relation in the from
clause...
select y.col1 from my_plpgsql_fn(789) y
but I need to pass the function
Gauthier, Dave dave.gauth...@intel.com writes:
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