Postgres Pro
Downloads
Home   >   mailing lists

Re: Returning NULL from SRF - Mailing list pgsql-novice

From Magnus Persson
Subject Re: Returning NULL from SRF
Date
Msg-id 52C98839.3000709@gmail.com
Whole thread Raw
In response to Returning NULL from SRF  (Magnus Persson <magnus.e.persson@gmail.com>)
List pgsql-novice
Tree view 
RhodiumToad set me on the right track.

Apparently there is no macro defined for returning null in a SRF. The
suggestion was to copy the SRF_RETURN_NEXT macro, defining it to call
PG_RETURN_NULL() instead of PG_RETURN_DATUM(_result). Worked like a charm!

pgsql-novice by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: total time more than 24 hours
Next
From: avpro avpro
Date:
Subject: how to add 'time with time zone' data types and 'interval' data types