On Fri, 4 Feb 2005 12:48:43 -0500, Merlin Moncure
<[EMAIL PROTECTED]> wrote:
> > Alexandre Leclerc wrote:
> > Sorry for jumping in on this thread so late -- I haven't been able to
> > select * from crosstab(
> >'select product_id, department_id, req_t
On Fri, 28 Jan 2005 10:24:37 -0800, Joe Conway <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc wrote:
> > I'm a little bit confused on how to install this contirb. I know my
> > contrib package is installed, but I don't know how to make it work in
> > postgresql
On Fri, 28 Jan 2005 08:34:27 -0800, Joe Conway <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc wrote:
> >>>>>Here a normal listing of design.product_department_time:
> >>>>> product_id | department_id | req_time
> >>>>>
On Fri, 28 Jan 2005 09:07:59 +0100, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Jan 2005 12:43:56 -0500, Alexandre Leclerc
> <[EMAIL PROTECTED]> wrote:
> > On Thu, 27 Jan 2005 17:27:40 +0100, Dawid Kuroczko <[EMAIL PROTECTED]>
> > wrote:
>
ze anything, ever (and most of the time,
> you shouldn't!).
Thank you for all you help and time for this.
Best regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 8: explain analyze is your friend
no more than 1 dimension and
> b: array bounds are known
>
> Let me know if you need it and I'll send it over.
Thank you for your offer. I think parsing an array is the easiest
thing to do for me in all this. :) If I encounter any problem, I'll
drop you a mail.
Regards.
--
jobs. :) This
is a nice report, but I don't want to kill the database each time the
user want to see it.
Thanks for your contrib so far, this will help me looking for other
ways doing it. I'm always ready to hear more!
Regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, 27 Jan 2005 17:27:40 +0100, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Jan 2005 10:23:34 -0500, Alexandre Leclerc
> <[EMAIL PROTECTED]> wrote:
> > Here a normal listing of design.product_department_time:
> > product
roduct. So someone can know how much work time there is to do by
departments.
Thanks for any input, comments, tips, help, positive criticism to
learn more, etc.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 8: explain analyze is your friend
On 24 Nov 2004 01:52:52 -0500, Greg Stark <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc <[EMAIL PROTECTED]> writes:
>
> > Thanks for those tips. I'll print and keep them. So in my case, the
> > product_code being varchar(24) is:
> > 4 bytes + string
ld be nice to see that. It
would be easier for the DB admin and the coder; the moment this is not
slowing the system. : )
Best regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
for any good pointers on this 'already seen' issue.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
s are exactly the same, should I assume
that the cost will also be the same?
Thanks for any help.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
.
Regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
jobs.product_id =
products.product_id;
in order to speed the union processing?
Thank you for any help on this.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
16 matches
Mail list logo
