Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

[no subject]



  IMMUTABLE indicates that the function always returns the same result
  when given the same argument values; that is, it does not do database
  lookups or otherwise use information not directly present in its
  argument list. If this option is given, any call of the function
  with all-constant arguments can be immediately replaced with the
  function value.

The function definition:


  CREATE OR REPLACE FUNCTION testme(integer) RETURNS text AS
  ' BEGIN
          RAISE NOTICE ''called'';
          return ''ret''::text;
  END ' LANGUAGE 'plpgsql' IMMUTABLE STRICT;


PostgreSQL version 8.0.0



--strk;




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group