upper() and lower() on varchar

From: Maarten Boekhold <maartenb(at)dutepp2(dot)et(dot)tudelft(dot)nl>
To: pgsql-sql(at)postgresql(dot)org
Subject: upper() and lower() on varchar
Date: 1998-09-01 10:04:43
Message-ID: Pine.SUN.3.91.980901120253.7792A-100000@dutepp2.et.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Is there a way to get upper() and lower() to work on a varchar column? It
seems like these functions are only defined on the text datatype (in 6.3.2).

I guess what I need in this case is some way to convert varchar to text.
Will (text_in(varchar_out(column)) work?

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Johann Spies 1998-09-01 11:57:12 pgaccess-forms.
Previous Message Johan.F.Strand 1998-08-31 11:47:57