Doubt about User-defined function.

From: "sathiya moorthy" <mail2sathiyamoorthy(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Doubt about User-defined function.
Date: 2006-07-15 10:38:14
Message-ID: 6534cdd0607150338j42f31e65vadfe975cb20cca2d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ).

Thanking you.

--
sathiyamoorthy

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Paul S 2006-07-15 12:00:42 Re: Querying for name/value pairs in reverse
Previous Message Stefan Arentz 2006-07-15 09:24:17 Querying for name/value pairs in reverse