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 b
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
Hi all,
I am using:
Debian 2.2 (kernel 2.2.18)
PgSQL version 7.0.3
I would like empty fields from a file being recognised as NULL values.
It doesn't seem to work when a COPY is done, but when I make an INSERT
without
specifying the value, this is recognised as a NULL
The file I want to copy is