On 09/19/2011 10:49 AM, Rob Sargent wrote:
Having a name space in the doc requires it's usage in the query.
yeah, I got it... I was using wrong one...
thanks.
On 09/17/2011 11:48 AM, boris wrote:
hi all,
I've inserted xml file :
http://www.w3.org/2001/XMLSchem
hi all,
I've inserted xml file :
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
zz
..
to a table:
CREATE TABLE "temp".tempxml
(
record xml
)
I can get it using:
select * from temp.tempxml
but, I can't get any values using xpath. ex:
Hi, this is my first on this list.
I can't understand where my problem in PG 8.4.
CREATE TABLE tbl( KEY int, val int);
Update query like:
UPDATE tbl SET val = 1
WHERE KEY = any('{0,1,2,3,4,5}'::int[])
returning key;
work well. But any try to wrap it in select query like:
Hello!
I want to say that it would be fantastic when you include the Oracle like
"CONNECT BY" patch (see gppl.terminal.ru/readme.html) in the next version of
PostgreSQL.
It is very usefull for people that have to handle such kind of hierarchical
data.
--
Dipl. Inform. Boris Klug,
Hello Francis,
Tuesday, January 02, 2001, 3:23:49 AM, you wrote:
FS> Hi Boris,
FS> I know Kaare Rasmussen posted a URL to the online documentation already,
FS> but this might be a direct solution to your problem:
FS> DELETE FROM onlineuser WHERE datum < ('now'::
ple delete entries older than 300 secounds.
I postet to the list because I have found no solution in the
tutorials and search-engine (maybe searched with wrong words?)
It would be great if someone could help me / point me to the right
way...
--
Boris
