Error prone compilation of stored procedure - Mailing list pgsql-general

From pinker
Subject Error prone compilation of stored procedure
Date
Msg-id 1436177299736-5856699.post@n5.nabble.com
Whole thread Raw
Responses Re: Error prone compilation of stored procedure  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Error prone compilation of stored procedure  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
What's the reason behind very "tolerant" error checking during stored
procedure compilation?
Why PostgreSQL allows using variable (j_var) that doesn't exists? It isn't
column name or isn't declared anywhere. Like in example below:

CREATE OR REPLACE FUNCTION test()
  RETURNS int AS
$BODY$
BEGIN

select 1 WHERE 1 > j_var;
    RETURN 2;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;



--
View this message in context: http://postgresql.nabble.com/Error-prone-compilation-of-stored-procedure-tp5856699.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: max number of locks
Next
From: Andreas Kretschmer
Date:
Subject: Re: Error prone compilation of stored procedure