From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
---|---|
To: | Safa Pilavcý <safa(dot)pilavci(at)rumeli(dot)net> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: Fw: [GENERAL] uppercase of char16 |
Date: | 1999-08-10 14:36:40 |
Message-ID: | 19990810093640.A27644@wallace.ece.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)pilavci(at)rumeli(dot)net>
> To: <pgsql-general(at)hub(dot)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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Wim Kerkhoff | 1999-08-10 14:57:36 | Selecting between dates |
Previous Message | Herouth Maoz | 1999-08-10 13:24:55 | Re: Fw: [GENERAL] uppercase of char16 |