[SQL] xml2 support

2011-03-23 Thread Rob Sargent
I'm confused by the deprecation notice on xml2 seen here http://www.postgresql.org/docs/9.0/interactive/xml2.html. 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

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 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 robjsarg...@gmail.com 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

[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

[SQL] xml2 support

2011-03-23 Thread Rob Sargent
I'm confused by the deprecation notice on xml2 seen here http://www.postgresql.org/docs/9.0/interactive/xml2.html. 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

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,

Re: [SQL] pg_attributte, data types

2011-03-23 Thread Tom Lane
=?UTF-8?Q?Viktor_Bojovi=C4=87?= viktor.bojo...@gmail.com 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

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 rsarg...@xmission.com wrote: