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: (view raw, whole thread or download thread mbox)
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: 

Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
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-2017 The PostgreSQL Global Development Group