Re: [GENERAL] Strange query plan

2008-08-14 Thread Thomas Burdairon
On 14 août 08, at 16:28, Dmitry Teslenko wrote: On Thu, Aug 14, 2008 at 17:55, Igor Neyman <[EMAIL PROTECTED]> wrote: -Original Message- From: Dmitry Teslenko [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 6:57 AM To: pgsql-general@postgresql.org Subject: Strange query plan

Re: [GENERAL] Problem with joining two tables

2007-12-05 Thread Thomas Burdairon
On 5 déc. 07, at 14:42, Przemyslaw Bojczuk wrote: Hello! I have a problem joining two tables. I tried various types of join and none seems to work as I expect Table 1: id | stuff --- 1 | sth1 2 | sth2 3 | sth3 4 | sth4 5 | sth5 .. | ... Table 2: id | desc | etc ---

Re: [GENERAL] delete with self join

2007-04-17 Thread Thomas Burdairon
On Apr 17, 2007, at 11:07, garry saddington wrote: I am keeping a record of siblings in a school. The user chooses one student and there siblings such that id's are entered into a table as such: TABLE SIBLINGS: principal sibling 809 234 809 785 809 345 809

Re: [GENERAL] Paranthesis and Driver JDBC

2007-03-28 Thread Thomas Burdairon
Hi Alberto You should upgrade to the most recent version of the jdbc driver : see the change log details ( http://jdbc.postgresql.org/ changes.html#version_8.0-315 ) When performing replace processing we must continue processing until we hit the end of a user supplied query, not just once w

Re: [GENERAL] Dynamic table with variable number of columns

2006-07-12 Thread Thomas Burdairon
if i understand well you need to have an history for your products.i would have a table B withdate           products            price1/1/2006     prod1                 1.01/1/2006     prod2                 3.0or replace prod_name py product_id, ... Thomas On Jul 12, 2006, at 16:08, [EMAIL PROTEC