Re: [BUGS] [SQL] plPGSQL bug in function creation

#1

"Marek Lewczuk" <newsy (AT) lewczuk (DOT) com> writes:

Quote:

CREATE FUNCTION "public"."test" (text, text) RETURNS text AS'
BEGIN
IF $1 THEN
RETURN $1;
ELSE
RETURN $2;
END IF;
END;
'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

If there's a bug here at all, it's that this function doesn't report a
type violation. What in the world do you think the semantics of that
IF-test are? text is not boolean.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [SQL] plPGSQL bug in function creation

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [SQL] plPGSQL bug in function creation - 09-08-2003 , 09:23 AM