I've tried it and it works well, thanks a lot Oliver.
Amanda
Oliver Elphick wrote:
> Amanda Riera wrote:
> >I would like concatenate some fields to have all information in just
> >one field. I'm doing this below:
> >
> >CREATE TABLE bill_2col AS
> >SELECT bill.bill_id,
> >
Amanda Riera wrote:
>I would like concatenate some fields to have all information in just
>one field. I'm doing this below:
>
>CREATE TABLE bill_2col AS
>SELECT bill.bill_id,
> (trim(text(bill.bill_number)) || ' | ' ||
> trim(text(provider.company)) || ' | ' ||
> trim(to_char(bi
Hi all,
using PgSQL 7.0.3
I would like concatenate some fields to have all information in just
one field. I'm doing this below:
CREATE TABLE bill_2col AS
SELECT bill.bill_id,
(trim(text(bill.bill_number)) || ' | ' ||
trim(text(provider.company)) || ' | ' ||
trim(to_char(bill.issue_date,'M