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
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
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.:
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
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