Search Postgresql Archives

Re: Varchar concatenate fields as Char or Varchar, not Text

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




>Rodrigo Gonzalez <rjgonzale@xxxxxxxxx> wrote on 08/07/2006 11:36:28 AM:
> Really, I dont see the 3 varchar fields concatenated to a new field.
>
> But do this....
>
> (varchar1||varchar2||varchar3||newfield)::varchar
>
> Best regards
>

This is the concatenate statement

> > SELECT b.ltname, (c.refullname::text || d.enname::text) ||
> > f.evname::text AS evlinkname1,

Margaret Gillon

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux