In the docs it says "Plan-reading is an art that deserves an extensive
tutorial, which this is not". Is there one? I've gone beyond simple
queries (which are performing well) to the more difficult queries (which
aren't).
e.g. 4 generation family tree implemented as a view using 14 left outer
j
Yes, I'm not worried about an exact DST. The date items are stored with Timestamp Timezone.
Thanks to everybody for your technical tips and help.
Hadley
On Mon, 2004-04-19 at 16:42, Tom Lane wrote:
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Hadley Willan <[EMAIL PROTECTED]> wrote:
>>
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Hadley Willan <[EMAIL PROTECTED]> wrote:
>> dateRange = ''now''::date - ( 7 * '1 week'::interval );
> If you actually are using a date you don't have to use an interval as
> the number subtracted will be in days. So you could just use
> current_date
Hadley Willan <[EMAIL PROTECTED]> writes:
> I take it I could just use ''now'' instead of a date
> dateRange = ''now''::date - ( 7 * '1 week'::interval );
You probably want to use the SQL-standard spelling:
dateRange = current_date - ( 7 * '1 week'::interval );
Aside from being standard, this
On Mon, Apr 19, 2004 at 11:18:23 +1200,
Hadley Willan <[EMAIL PROTECTED]> wrote:
> Thanks, that's pretty easy.
>
> I take it I could just use ''now'' instead of a date
>
> dateRange = ''now''::date - ( 7 * '1 week'::interval );
If you actually are using a date you don't have to use an interval
Andrew Dunstan wrote:
Christopher Kings-Lynne said:
But you would have to assign the copyright to them
If someone is going to make money from my code, I prefer it to be me,
or at least that everyone has a chance to do so rather than just one
company.
Well, then for the same reas
Shachar Shemesh wrote:
Tom Lane wrote:
These tools are a not insignificant part of our Plan for World
Domination ;-) so it would be good if somebody stepped up to the
plate and volunteered to take care of 'em. Anybody?
Which brings me to another question
I have a bunch of perl scripts, as
Tom Lane wrote:
These tools are a not insignificant part of our Plan for World
Domination ;-) so it would be good if somebody stepped up to the
plate and volunteered to take care of 'em. Anybody?
Which brings me to another question
I have a bunch of perl scripts, as well as one user-defined t
Christopher Kings-Lynne said:
>> But you would have to assign the copyright to them
>>
>> If someone is going to make money from my code, I prefer it to be me,
>> or at least that everyone has a chance to do so rather than just one
>> company.
>
> Well, then for the same reason we should writ
