"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > 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. INTO requires a declared variable as target. However, I'm wondering why you don't just use "RETURN expression" if this is all that will be in the function. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
