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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
