Re: missing function? - Mailing list pgsql-novice

From Keith Worthington
Subject Re: missing function?
Date
Msg-id 20041127182545.M39463@narrowpathinc.com
Whole thread Raw
In response to Re: missing function?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
> > 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


pgsql-novice by date:

Previous
From: Antoine
Date:
Subject: Re: Front end suggestions??
Next
From: Tom Lane
Date:
Subject: Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"