Re: manipulate and return row inside a function

I solved it with using COALESCE.

Best,
c.

On Thu, Nov 14, 2013 at 9:03 AM, Luca Ferrari <fluca1978(at)infinito(dot)it> wrote:

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