On Thu, Nov 14, 2013 at 8:50 AM, Claudio Poli <masterkain@gmail.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