Hmm, char16 is not a currently recognized type - what version of
postgresql are you using? In 6.5, upper(foo) works for all the char and
text types of foo I can find.
Ross
On Tue, Aug 10, 1999 at 02:30:54PM +0300, Safa Pilavcý wrote:
> Please help....
>
>
> ----- Original Message -----
> From: Safa Pilavc? <safa.pilavci@rumeli.net>
> To: <pgsql-general@hub.org>
> Sent: 06 A?ustos 1999 Cuma 14:48
> Subject: [GENERAL] uppercase of char16
>
>
> > hello ,
> > My problem is with SQL statement,
> > I have a field like,
> > my_field char16
> >
> > this field contains charecters all lowercase but I want to get them
> uppercase as a
> > result of select statement..
> > I have tried ;
> > select upper(my_field) from my_table;
> > but the followwing error occured.
> >
> > function upper(char16) does not exist
> >
> > How can I get uppercase output of my_field....
> >
> >
> > Safa Pilavc?
> >
> >
> >
>
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005