Re: How to cast a char[] to varchar?

From: Jon Lapham <lapham(at)extracta(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to cast a char[] to varchar?
Date: 2002-01-07 19:16:54
Message-ID: 3C39F426.10904@extracta.com.br
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> regression=# create function to_varchar(char[]) returns varchar as '
> regression'# begin
> regression'# return $1;
> regression'# end;' language 'plpgsql';

Thanks Tom, works great.

--

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter E. Chen 2002-01-07 21:22:48 Question regarding strings . . .
Previous Message Ian Harding 2002-01-07 18:54:48 Re: 7.2 changes to varchar truncation