Skip site navigation (1) Skip section navigation (2)

Re: Receive a record not a tuple - plpgsql

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: Flávio Brito <flavio(at)gral(dot)org(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Receive a record not a tuple - plpgsql
Date: 2005-11-21 04:42:42
Message-ID: 7D3B24F0-256E-4DC7-A32B-75ABEE53D83F@sitening.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Nov 16, 2005, at 2:21 PM, Flávio Brito wrote:

> How can I call a function into a function? My problem is: I'm  
> trying to calculate a tax(inss) over a employer salary. I created a  
> function called inss that do it correctly, but when I create  
> another one to show more attributes (inss is not a attribute, it is  
> calculate over a salary) I receive a record (like {1,Mary,32.45}  
> not a tuple. How can I solve it?

Have you looked into set-returning functions? It seems like that  
might be what you're looking for:

http://www.postgresql.org/docs/8.1/static/plpgsql-control- 
structures.html#PLPGSQL-STATEMENTS-RETURNING

--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)

In response to

pgsql-admin by date

Next:From: Enzo D'addarioDate: 2005-11-21 05:08:32
Subject: triggers
Previous:From: Gregory S. WilliamsonDate: 2005-11-21 00:43:33
Subject: Re: Server Hardware Configuration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group