From: Aaron Bono <postgresql@aranya.com>
To: sathiya moorthy <mail2sathiyamoorthy@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Doubt about User-defined function.
Date: Sat, 15 Jul 2006 17:10:14 -0500
Message-ID: <bf05e51c0607151510i6394bcd6o2ab596d624afe793@mail.gmail.com> (raw)
In-Reply-To: <6534cdd0607150338j42f31e65vadfe975cb20cca2d@mail.gmail.com>
References: <6534cdd0607150338j42f31e65vadfe975cb20cca2d@mail.gmail.com>
I am really confused about what your question is. Functions can take zero
to many arguments and return one value. The argument types are different
from (or at least are independent of) the return value. Arguments are not
returned, they are passed into the function. Your use of the terminology
appears to be inconsistent with the definitions of these words.
-Aaron
On 7/15/06, sathiya moorthy <mail2sathiyamoorthy@gmail.com> wrote:
>
> I have doubt about user-defined function returns value :
>
> * why function returns( accepts ) One attribute in the
> arguments of function/table, Otherwise it returns the whole record of the
> table. Function accept more than arguments .
> * Why it doesn`t return more than one arguments in
> the function (or) Attribute of that table.
>
> * Its like same as C-language function, Because in C
> function returns one value (or) structure/array of characters.
>
> * My question is, In psql user-defined function doesn`t
> returns more than one attribute. Is it possible (or) Not.
>
> Some examples :
> i) create function com2(text,integer) returns text as '
> select city.city from city,weather
> where weather.city=$1 AND city.pop>$2' language sql;
>
> Res : Return type of the function is Text, As well as
> it is one of the argument of function.
> ( At the type of returning, why it doesn`t
> also accepts integer ).
> ii) create function usrs_tab(text,integer) returns city as
> 'select city.city,city.pop,city.state from
> city,weather where weather.city=$1 AND city.pop>$2'
> language sql;
>
> Res : Return one record from City table ( table
> contains city, pop, state only ).
>
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, mail2sathiyamoorthy@gmail.com
Subject: Re: Doubt about User-defined function.
In-Reply-To: <bf05e51c0607151510i6394bcd6o2ab596d624afe793@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox