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? <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
