diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/trigger.sgml | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index 540ef0f71b3..10a49244b4c 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -1,3 +1,7 @@ +<!-- +$Header: /cvsroot/pgsql/doc/src/sgml/trigger.sgml,v 1.19 2001/12/04 02:07:11 tgl Exp $ +--> + <chapter id="triggers"> <title>Triggers</title> @@ -451,7 +455,7 @@ PG_FUNCTION_INFO_V1(trigf); Datum trigf(PG_FUNCTION_ARGS) { - TriggerData *trigdata = (TriggerData *) fcinfo->context; + TriggerData *trigdata = (TriggerData *) fcinfo->context; TupleDesc tupdesc; HeapTuple rettuple; char *when; @@ -490,8 +494,12 @@ trigf(PG_FUNCTION_ARGS) if (ret < 0) elog(NOTICE, "trigf (fired %s): SPI_exec returned %d", when, ret); - - i = SPI_getbinval(SPI_tuptable->vals[0], SPI_tuptable->tupdesc, 1, &isnull); + + /* count(*) returns int8 as of PG 7.2, so be careful to convert */ + i = (int) DatumGetInt64(SPI_getbinval(SPI_tuptable->vals[0], + SPI_tuptable->tupdesc, + 1, + &isnull)); elog (NOTICE, "trigf (fired %s): there are %d tuples in ttest", when, i); @@ -499,7 +507,7 @@ trigf(PG_FUNCTION_ARGS) if (checknull) { - i = SPI_getbinval(rettuple, tupdesc, 1, &isnull); + (void) SPI_getbinval(rettuple, tupdesc, 1, &isnull); if (isnull) rettuple = NULL; } |