[GENERAL] pgxml & xpath_table

2006-06-08 Thread Philippe Lang
Hi, I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure if what I found with pgxml is a feature of a bug: I've got the following table: CREATE TABLE test ( id int4 NOT NULL, xml varchar(200), CONSTRAINT pk PRIMARY KEY (id) ) WITHOUT OIDS; INS

Re: [GENERAL] pgxml & xpath_table

2006-06-09 Thread John Gray
Hi, On Fri, 09 Jun 2006 08:43:51 +0200, Philippe Lang wrote: > I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure > if what I found with pgxml is a feature of a bug: > [snip] > I get: > > > iddoc_num line_numval1val2val3 > 1

Re: [GENERAL] pgxml & xpath_table

2006-06-10 Thread Tom Lane
John Gray <[EMAIL PROTECTED]> writes: > This is the reason why xpath_table allows you to specify an > identifying field (usually a primary key but doesn't have to be)- the > solution to your question is to join an xpath_table that just fetches the > document number against the primary key, e.g.:

Re: [GENERAL] pgxml & xpath_table

2006-06-10 Thread John Gray
On Sat, 2006-06-10 at 14:06 -0400, Tom Lane wrote: > John Gray <[EMAIL PROTECTED]> writes: > > This is the reason why xpath_table allows you to specify an > > identifying field (usually a primary key but doesn't have to be)- the > > solution to your question is to join an xpath_table that just fet

Re: [GENERAL] pgxml & xpath_table

2006-08-21 Thread Bruce Momjian
John Gray wrote: > On Sat, 2006-06-10 at 14:06 -0400, Tom Lane wrote: > > John Gray <[EMAIL PROTECTED]> writes: > > > This is the reason why xpath_table allows you to specify an > > > identifying field (usually a primary key but doesn't have to be)- the > > > solution to your question is to join a