Re: Multiple return values and assignment

On 2009-04-25, Leif B. Kristensen <leif(at)solumslekt(dot)org> wrote:
> I've got a function that returns both an integer and a string as a
> user-defined composite type int_text:
>
> -- CREATE TYPE int_text AS (number INTEGER, string TEXT);
>
> Basically, the function does some heuristics to extract a sort order
> number from a text, and conditionally modify the text:
>
> CREATE OR REPLACE FUNCTION get_sort(INTEGER, INTEGER, TEXT)
> RETURNS int_text AS $$
...

> To use the two values in an other function where I've declared a
> variable sort_text of type int_text, I do like this:
>
> SELECT number, string FROM get_sort(par_id, srt, txt) INTO sort_text;

the above is equivalent to
sort_text = get_sort(par_id, srt, txt);

> srt := sort_text.number;
> txt := sort_text.string;

> But I feel it's a little awkward. Is there a more elegant way to do it?

SELECT * FROM get_sort(par_id, srt, txt) INTO srt,txt;