Обсуждение: Fw: [GENERAL] uppercase of char16

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ı
>
>
>

At 14:30 +0300 on 10/08/1999, =?iso-8859-9?Q?Safa_Pilavc=FD?= wrote:


> Please help....

Char16 has little support. Any possibility of changing the definition to
char(16)?

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

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