Postgres Pro
Downloads
Home   >   mailing lists

Thread: About the char16 and char(16);

About the char16 and char(16);

From
Christopher Luk
Date:
hi,
Can somebody tell me the difference in char16, char(16)?
I found a .c program in the package of the v6.3 of postgres that can
concat two char16 strings to one, is there any method that can easily
concat two char(80) or char(30) to a string?

--
Regards, Christopher Luk
   System Analyst - The Hong Kong Council of the Church of Christ in
China
              Phone : (852) 2397-1022 Fax : (852) 2397-7405
     mailto:wluk@hkcccc.org URL : http://www.hkcccc.org (Chinese based)

Re: [INTERFACES] About the char16 and char(16);

From
"Jose' Soares Da Silva"
Date:
On Wed, 25 Mar 1998, Christopher Luk wrote:

> hi,
> Can somebody tell me the difference in char16, char(16)?
> I found a .c program in the package of the v6.3 of postgres that can
> concat two char16 strings to one, is there any method that can easily
> concat two char(80) or char(30) to a string?

try using concatenation operator ||

SELECT string_of_80 || string_of_30 FROM mytable;
it works.
                                                         Jose'

Re: [INTERFACES] About the char16 and char(16);

From
The Hermit Hacker
Date:
On Wed, 25 Mar 1998, Christopher Luk wrote:

> hi,
> Can somebody tell me the difference in char16, char(16)?

    char16 won't exist in 6.4...its being removed...

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org