diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2002-09-15 13:04:16 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2002-09-15 13:04:16 +0000 |
| commit | 5ea9322872c65c5353a305ca5f1c4acfcb486569 (patch) | |
| tree | 050cf76c6d96989f556585db699ca062b0adef1f | |
| parent | db4f3c033448ee56bda2244f9ce868297887b73a (diff) | |
| download | postgresql-5ea9322872c65c5353a305ca5f1c4acfcb486569.tar.gz postgresql-5ea9322872c65c5353a305ca5f1c4acfcb486569.zip | |
Cast functions can be immutable or stable.
| -rw-r--r-- | doc/src/sgml/ref/create_cast.sgml | 4 | ||||
| -rw-r--r-- | src/backend/commands/functioncmds.c | 6 |
2 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/create_cast.sgml b/doc/src/sgml/ref/create_cast.sgml index 00a44719662..bc9f71e566e 100644 --- a/doc/src/sgml/ref/create_cast.sgml +++ b/doc/src/sgml/ref/create_cast.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_cast.sgml,v 1.3 2002/09/01 02:37:02 tgl Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_cast.sgml,v 1.4 2002/09/15 13:04:16 petere Exp $ --> <refentry id="SQL-CREATECAST"> <refmeta> @@ -117,7 +117,7 @@ INSERT INTO foo(f1) VALUES(42); be schema-qualified. If it is not, the function will be looked up in the path. The argument type must be identical to the source type, the result data type must match the target type of - the cast. Cast functions must be marked immutable. + the cast. Cast functions must be marked immutable or stable. </para> </listitem> </varlistentry> diff --git a/src/backend/commands/functioncmds.c b/src/backend/commands/functioncmds.c index 47ebe0d7612..a935dae7e6e 100644 --- a/src/backend/commands/functioncmds.c +++ b/src/backend/commands/functioncmds.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/functioncmds.c,v 1.19 2002/09/04 20:31:15 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/functioncmds.c,v 1.20 2002/09/15 13:04:16 petere Exp $ * * DESCRIPTION * These routines take the parse tree and pick out the @@ -676,8 +676,8 @@ CreateCast(CreateCastStmt *stmt) elog(ERROR, "argument of cast function must match source data type"); if (procstruct->prorettype != targettypeid) elog(ERROR, "return data type of cast function must match target data type"); - if (procstruct->provolatile != PROVOLATILE_IMMUTABLE) - elog(ERROR, "cast function must be immutable"); + if (procstruct->provolatile == PROVOLATILE_VOLATILE) + elog(ERROR, "cast function must not be volatile"); if (procstruct->proisagg) elog(ERROR, "cast function must not be an aggregate function"); if (procstruct->proretset) |