Re: manipulate and return row inside a function

On Thu, Nov 14, 2013 at 8:50 AM, Claudio Poli <masterkain(at)gmail(dot)com> wrote:
> some other things I'm trying:
>
> SELECT
> pick_artist(album_artist, artist) AS artist,
>
>
>
> CREATE OR REPLACE FUNCTION pick_artist(album_artist varchar, album
> varchar)
> RETURNS varchar AS $$
> BEGIN
> IF album_artist IS NULL THEN RETURN album;
> ELSIF album_artist = '' THEN RETURN album;
> ELSE RETURN album_artist;
> END IF;
> END;
> $$ LANGUAGE plpgsql;
>
>

This works fine for me:
select * from pick_artist( ROW('a','b') );
on 9.3.
I don't know what is complaining about in your case.

Luca