Re: Function not return zero record

Sylvain Racine wrote:
> Hello,
>
> I wrote a simple function who checks in a table an address and returns
> the id and coordinates of the corresponding address.
>
> The problem is when I run separately the SQL query, it gives me zero (0)
> entry when I submit a new address - it is what I want as result - and
> when I run my function, it gives me 1 entry with the same address.
>
> Note: I create a pseudo-type to return the result. Is that my problem?

The problem is the difference between a value of type getCache and a set
of values of type getCache.

Define your function as returning a SETOF getCache
Call it with SELECT * FROM getCache(...)

HTH

--
Richard Huxton
Archonet Ltd