I know this could be written quite easily in sql but was wondering if it is
possible in pl/pgsql.

CREATE FUNCTION test_func()
RETURNS text
LANGUAGE 'plpgsql'
AS $$
BEGIN
SELECT 'text_to_return' INTO <what_goes_here?>; --with or without a cast
RETURN <what_goes_here?>;
END;
$$;

The goal is to return the value of text_to_return without declaring an
explicit variable to name in the INTO clause.

I thought there was an implicit variable available to me but cannot figure
out what it is nor find it in the documentation.

Using 9.3 but figuring if it is possible its likely the same in all
supported releases...

Thanks!

David J.

Reply via email to