Postgres Pro
Downloads
Home   >   mailing lists

Re: Update field to a column from another table - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Re: Update field to a column from another table
Date
Msg-id CAE_gQfVFsxmjR-eH_iBZy1_VWGXL4nrX0ard-8NiJ=eN5X9+nA@mail.gmail.com
Whole thread Raw
In response to Re: Update field to a column from another table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Update field to a column from another table
Re: Update field to a column from another table
List pgsql-general
Tree view
So when I run:

UPDATE ja_jobs t2
SET time_job = t1.time_job
FROM junk.ja_test t1
WHERE t2.id = t1.id
AND t2.time_job IS DISTINCT FROM t1.time_job;

I get:

UPDATE 2202

So I check the data by doing:

select * FROM public.ja_jobs WHERE id = 14574527

And the "time_job" field is null....


pgsql-general by date:

Previous
From: John W Higgins
Date:
Subject: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Next
From: "David G. Johnston"
Date:
Subject: Re: Update field to a column from another table