Keith Devens .com

Why didn't he just do this

Create table mytable{
a varchar,
b varchar
}

insert into mytable('apples','green')
insert into mytable('apples','red')

select /mydatabase/mytable[@a = 'apples' position() = first())

I don't think your question is serious, but here is an answer:

select /mydatabase/mytable[@a = 'apples' position() = first()) is not possible in PostgreSQL because /mydatabase/mytable[@a = 'apples' position() = first()) is invalid SQL