> > We just started to play with the 8.0.0 Beta and can't seem to
> > find the function lower() which we used in our where clauses
> > to lower case text. Can anyone explain where it can be found.
>
> What do you mean "can't seem to find"? What error or unexpected
> results are you getting? What happens when you execute the
> following statement?
>
> SELECT lower('ABC');
>
> If that works but another query doesn't, then please post the
> simplest possible example that demonstrates the problem.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
Executing the above SQL statement works fine on both our 7.3.6 and 8.0.0 Beta4
servers. So obviously the server itself is fine. The Beta4 server is a
windows based system. When using pgadmin and expanding functions under public
the lower() function is not displayed. But that is true on either server so I
do not put much faith in that fact. We are using Visual Basic 6 to talk to
both servers. It seems like we may be having an issue with the ADO control
that is between VB6 and postgreSQL. Thanks for your help.
______________________________________________
99main Internet Services http://www.99main.com