query question
I am new to using postgresql and have the following question. if i submit
a query (through a perl script), what values (and in what order) will be
returned to me? here is my query:
SELECT p.ids_name, m.start_time, m.end_time
FROM mail_schedule m, personnel p
WHERE p.ids_int = m.ids_int AND
m.dow = $weekday AND
$timestamp BETWEEN m.start_time AND m.end_time
UNION
SELECT p.ids_name, c.on_start, c.on_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int AND
$timestamp BETWEEN c.on_start AND c.on_end
EXCEPT
SELECT p.ids_name, c.off_start, c.off_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int AND
$timestamp BETWEEN c.off_start AND c.off_end
thanks in advance for any assistance you can provide.
chris mutchler
davron@leibnizcreations.com
We run several web based postgresql applications and find it difficult to
make changes in a safe and reliable manner.
We have test databases that mirror the live ones. When we have finished
making the testing the updated version, we labouriously go through and copy
all the changes onto the live system. Obviously the live system has to be
taken down during this.
Is is possible to do the following:
stop postmaster
copy all files from ~postgres/base/testdb/* -> ~postgres/base/livedb/*
restart postmaster
All the tables, indexes etc have the same names in both, but we may
add/alter columns for the new version.
Thanks
Steve
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk