[SQL] xml2 support

2011-03-23 Thread Rob Sargent
I'm confused by the deprecation notice on xml2 seen here . What if anything was removed in the making of 8.4? Was the newer standard API implemented? Do I still need namespaces? I'm running PostgreSQL 9.0.3 built locally with --with-li

Re: [SQL] xml2 support

2011-03-23 Thread Serdar Gül
if you want to export the data in xml type i suggest you to use the EMS SQL Manager for PostgreSQL because you can export the whole table or an executed query in many different file types including xml 2011/3/23 Rob Sargent > I'm confused by the deprecation notice on xml2 seen > here

Re: [SQL] xml2 support

2011-03-23 Thread Rob Sargent
On 03/23/2011 11:10 AM, Serdar Gül wrote: if you want to export the data in xml type i suggest you to use the EMS SQL Manager for PostgreSQL because you can export the whole table or an executed query in many different file types including xml 2011/3/23 Rob Sargent mailto:robjsarg...@gmail.com

Re: [SQL] xml2 support

2011-03-23 Thread Serdar Gül
sorry i misunderstood you i am new in postgresql so i advice the first thing i thought so sorry 2011/3/23 Rob Sargent > > > On 03/23/2011 11:10 AM, Serdar Gül wrote: > >> if you want to export the data in xml type >> i suggest you to use the EMS SQL Manager for PostgreSQL >> because >> you can e

[SQL] Obscure behavior of ORDER BY

2011-03-23 Thread Tambet Matiisen
Hi everyone! I recently noticed obscure behavior of ORDER BY. Consider this example: select email from ( select '@'::text as email union all select '.'::text as email ) a order by email; The result is: email --- . @ (2 rows) This is all normal - I expect, that dot is smaller than ampers

[SQL] xml2 support

2011-03-23 Thread Rob Sargent
I'm confused by the deprecation notice on xml2 seen here . What if anything was removed in the making of 8.4? Was the newer standard API implemented? Do I still need namespaces? I'm running PostgreSQL 9.0.3 built locally with --with-li

Re: [SQL] Obscure behavior of ORDER BY

2011-03-23 Thread Pavel Stehule
Hello this behave depends on your language rules. So this behave can be ok. pavel=# select * from (values('.'),('@'),('.xxx'),(' ')) x order by 1; column1 ─ . @ .xxx (4 rows) you can se so string with space on start is on end and this is correct, because spaces and white

[SQL] pg_attributte, data types

2011-03-23 Thread Viktor Bojović
while listing data types i have noticed that some types have underscore prefix but i don't know why is that. so im asking if somene can tell me. These are type examples: _char _float4 _int2 _oid _regtype _text _varchar select distinct typname from ( SELECT attname AS name, attnum , typname, attt

Re: [SQL] pg_attributte, data types

2011-03-23 Thread Tom Lane
=?UTF-8?Q?Viktor_Bojovi=C4=87?= writes: > while listing data types i have noticed that some types have underscore > prefix but i don't know why is that. so im asking if somene can tell me. > These are type examples: > _char > _float4 > _int2 > _oid > _regtype > _text > _varchar Those are array t

Re: [SQL] xml2 support

2011-03-23 Thread Isaac T. Dover
I believe that 8.3 introduced the SQL/XML standard. "With-libxml" is the contribution that enables this, so it's most likely what you're using. Some commercial vendors have also adopted this standard. http://en.wikipedia.org/wiki/SQL/XML Thanks, Isaac Rob Sargent wrote: >I'm confused by the