On Wed, Oct 29, 2008 at 6:36 PM, Tom Lane [EMAIL PROTECTED] wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, Oct 29, 2008 at 4:23 PM, Tom Lane [EMAIL PROTECTED] wrote:
If you can tolerate losing the data on that page, just zero out the
entire 8K page. dd from /dev/zero is the usual
On Wed, Oct 29, 2008 at 7:24 PM, Scott Marlowe [EMAIL PROTECTED]
wrote:
Oh, and to reply to myself and the original poster, you need to figure
out what's causing the pages to get damaged. IT's usually bad
hardware, then a buggy driver, then a buggy kernel / OS that can cause
it. Run lots
alias v not visible in sub-query?
- Original Message -
From: Pascal Tufenkji
To: pgsql-sql@postgresql.org
Sent: Thursday, October 30, 2008 12:17 PM
Subject: [SQL] Subqueries
Hello,
I don't understand the following error.
Can anyone help me plz
Thx
Pascal
The v reference need to exist in the inner query. You can't use an outer
query reference in the inner query.
This happens because the inner query is executed before the outer query and
the inner query doesn't even know about the outer query.
May be this helps you get what you want.
SELECT *,
Hello,
I don't understand the following error.
Can anyone help me plz
Thx
Pascal
select *
from sip_vacations_v v
left join
(
select pe.emp_id,mg.mat_id,mg.groupe,count(p.id) * 1.5 as nb_heures
from mat_grp_v mg
inner join planification_v p on p.mat_grp_id =
Hey all,
I'm apparently too lazy to figure this out on my own so maybe one of you can
just make it easy on me. J
I want to index a timestamp field but I only want the index to include the
-mm-dd portion of the date, not the time. I figure this would be where
the expression portion
On Thu, Oct 30, 2008 at 2:49 PM, Ryan Hansen
[EMAIL PROTECTED] wrote:
Hey all,
I'm apparently too lazy to figure this out on my own so maybe one of you can
just make it easy on me. J
I want to index a timestamp field but I only want the index to include the
-mm-dd portion of the