Hi all;
I have a query that does this:
update tab_x set (inactive_dt, last_update_dt) =
((select run_dt from current_run_date), (select run_dt from
current_run_date))
where
cust_id::text || loc_id::text in
(select cust_id::text || loc_id::text from summary_tab);
The current_run_date table
am Mon, dem 19.05.2008, um 23:56:27 -0600 mailte kevin kempter folgendes:
Hi all;
I have a query that does this:
update tab_x set (inactive_dt, last_update_dt) =
((select run_dt from current_run_date), (select run_dt from
current_run_date))
where
cust_id::text || loc_id::text in
Hello List,
As an editor for the german Linux Magazine I am looking for Authors who would
want to write an article of about 5-7 pages (=15-2 characters) on Postgres
Troubleshooting and Performance issues. The Article is planned for our
forthcoming Linux Technical Review 09 - Datenbanken,
In response to Markus Feilner [EMAIL PROTECTED]:
As an editor for the german Linux Magazine I am looking for Authors who would
want to write an article of about 5-7 pages (=15-2 characters) on
Postgres
Troubleshooting and Performance issues. The Article is planned for our
On Mon, May 19, 2008 at 11:56 PM, kevin kempter
[EMAIL PROTECTED] wrote:
Hi all;
I have a query that does this:
update tab_x set (inactive_dt, last_update_dt) =
((select run_dt from current_run_date), (select run_dt from
current_run_date))
where
cust_id::text || loc_id::text in
(select
Hi all;
I have 2 tables where I basically want to delete from the first table
(seg_id_tmp7) any rows where the entire row already exists in the
second table (sl_cd_segment_dim)
I have a query that looks like this (and it's slow):
delete from seg_id_tmp7
where
Version 8.3.1
On May 20, 2008, at 1:51 PM, kevin kempter wrote:
Hi all;
I have 2 tables where I basically want to delete from the first
table (seg_id_tmp7) any rows where the entire row already exists in
the second table (sl_cd_segment_dim)
I have a query that looks like this (and
On Tue, 20 May 2008 22:03:30 +0200, kevin kempter
[EMAIL PROTECTED] wrote:
Version 8.3.1
On May 20, 2008, at 1:51 PM, kevin kempter wrote:
Hi all;
I have 2 tables where I basically want to delete from the first table
(seg_id_tmp7) any rows where the entire row already exists in the
Hi,
I am currently designing a database and wanted to know something that may
sound trivial, but I thought its still good to confirm before dumping
millions of rows in it.
The design requires a few master tables with very limited rows, for e.g.
currency_denomination table could at the max have a