Re: [SQL] pg_attributte, data types

2011-03-24 Thread Viktor Bojović
On Thu, Mar 24, 2011 at 12:56 AM, Tom Lane t...@sss.pgh.pa.us wrote: =?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

[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