Mike Plemmons wrote:
These are great tips! I will be more specific the next time I post.
Regarding the ineffiencient query. What do you suggest as a better way? I
would rather learn proper methods than continue to use improper ones.
Just send the query directly from the application - the way y
Mike Plemmons wrote:
I am trying to run this function but the return is not correct. If I run the
select statement from the psql command line it works. My guess is that the
WHERE clause could be causing the problem. Then again, it may be how I am
using the FOR loop. The ides column is of type TEX
Mike Plemmons wrote:
I am trying to run this function but the return is not correct.
PS - next time, details of what it *did* return and why that wasn't
correct would be useful. Not needed in this case, but good practice anyway.
PPS - the subject line was pretty good, but better might have b
Mike,
> I am trying to run this function but the return is not
> correct. If I run the select statement from the psql command
> line it works. My guess is that the WHERE clause could be
> causing the problem. Then again, it may be how I am using
> the FOR loop. The ides column is of type T
I have been looking through FAQs and the docs and I cannot seem to find
the answer to this question. If someone can point me to
documentation I would really appreciate it.
I am trying to run this function but the return is not correct.
If I run the select statement from the psql command line it
