Re: Help with a very newbie question... - Mailing list pgsql-general

Pavel Stehule wrote:
>>If I did the following:
>>SELECT * FROM "Users";
>>I get:
>>
>>userid  | passwd
>>----------+--------
>> cristian | hola
>>
>>AND I execute:
>>SELECT getuser('cristian', 'hola');
>>
>>I get:
>>     getuser
>>-----------------
>> (cristian,hola)
>>
>
> There are two posibilities
>
> SELECT getuser('cristian','hola');
> SELECT * FROM getuser('cristian','hola') AS (userid varchar, passwd
> varchar);

Or, define your function as ... RETURNS SETOF Users

--
   Richard Huxton
   Archonet Ltd