HI All,
I have requirement to use save point. But I am using session bean whose
transaction is managed by container. While executing sql insert I got unique
key constraint because of this my other command following this exception got
ignored. I want to continue my transaction even after this
John Fabiani, 23.09.2011 04:49:
I need to find the max(date) of a field but I need that value later in my
query.
If I
select max(x.date_field) as special_date from (select date_field) from table
where ...)x
I get one row and column.
But now I want to use that field in the rest of the query
Hello, My question is a basic one for postGIS, I believe. It should have a
primitive answer somewhere, but I don't have it. I want to get the extensions
of spatial table. Say that there is a spatial table named 'roads', and a some
road geometry inside. I want to fetch the bounding box
I am trying to use xpath to extract some information from a XML document.
(if it matters, It's the router config for a Juniper router)
I believe I am having problems with the namespace.
I am trying to extract the serial-number, but I am not getting anything.
Here is the script I have been
2011/9/22 Brian Sherwood bds...@gmail.com
select (xpath('/chassis-inventory/chassis/serial-number/text()',
data_xml,
ARRAY[ARRAY['junos',
'http://xml.juniper.net/junos/9.6R4/junos-chassis']]
)) from xml_test;
Can anyone suggest how I would go about getting the
2011/9/22 Asli Akarsakarya aslia...@yahoo.com
I want to get the extensions of spatial table. Say that there is a spatial
table named 'roads', and a some road geometry inside. I want to fetch the
bounding box (envelope or extension) for that table, that means for all the
roads that it
Hi,
I'd like to have a function that looks up an id of an item.
In case the item doesn't exist in the table yet it should be inserted
and the new id should be returned.
From the PG docu, I took the merge_db sample and modified it a bit.
This works but I'm wondering if INSERT part could be