Re: [SQL] Question about functions

2005-10-17 Thread Richard Huxton
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

Re: [SQL] Question about functions

2005-10-17 Thread Richard Huxton
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

Re: [SQL] Question about functions

2005-10-17 Thread Richard Huxton
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

Re: [SQL] Question about functions

2005-10-17 Thread Stewart Ben (RBAU/EQS4) *
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