* Tom Lane <[EMAIL PROTECTED]> wrote:
> Enrico Weigelt <[EMAIL PROTECTED]> writes:
> > c) CREATE FUNCTION id2username(oid) RETURNS text 
> >     LANGUAGE 'SQL' IMMUTABLE AS '
> >     SELECT username AS RESULT FROM users WHERE uid = $1';
> 
> This is simply dangerous.  The function is *NOT* immutable (it is
> stable though).  When ... not if ... your application breaks because
> you got the wrong answers, you'll get no sympathy from anyone.

In my case it is immutable. The username never changes.


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service

  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     [EMAIL PROTECTED]
  cellphone: +49 174 7066481
---------------------------------------------------------------------
 -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to