Re: PG_RETURN_? - Mailing list pgsql-general

From Richard Huxton
Subject Re: PG_RETURN_?
Date
Msg-id 44571544.1070205@archonet.com
Whole thread Raw
In response to PG_RETURN_?  (Don Y <pgsql@DakotaCom.Net>)
Responses Re: PG_RETURN_?
List pgsql-general
Don Y wrote:
> Hi,
>
> I have a set of functions for a data type that return
> small integers (i.e. [0..12]).  I can, of course, represent
> it as a char, short or long (CHAR, INT16 or INT32).
> re there any advantages/drawbacks to chosing one particular
> PG_RETURN_ type over another (realizing that they are
> effectively just casts)?

If they are integers then an int would be the obvious choice. If you are
going to treat them as int2 outside the function then int2, otherwise
just integer. Oh, it's int2/int4 not int16/int32.
--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Noel Faux
Date:
Subject: Re: How to join to delete
Next
From: Richard Huxton
Date:
Subject: Re: How to join to delete