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
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
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
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
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
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
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,
=?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
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: