very frustrating feature-bug - Mailing list pgsql-sql

From silly sad
Subject very frustrating feature-bug
Date
Msg-id 4B7B98AF.9050202@bankir.ru
Whole thread Raw
List pgsql-sql
acc=>

CREATE OR REPLACE FUNCTION add_user (TEXT, TEXT, TEXT, TEXT)
RETURNS usr AS $$  INSERT INTO usr (login,pass,name,email) VALUES ($1,$2,$3,$4)  RETURNING usr.*;
$$ LANGUAGE sql SECURITY DEFINER;

acc=>

ERROR:  return type mismatch in function declared to return usr
DETAIL:  Function's final statement must be a SELECT.
CONTEXT:  SQL function "add_user"

SURPRISE :-) SURPRISE :-)


pgsql-sql by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: Re: UNION or LEFT JOIN?
Next
From: Jasen Betts
Date:
Subject: Re: very frustrating feature-bug