Re: [SQL] pg_attributte, data types
On Thu, Mar 24, 2011 at 12:56 AM, Tom Lane wrote: > =?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 types. The normal convention is that foo[] is named > "_foo" under the surface. > >regards, tom lane > thanx -- --- Viktor Bojović --- Wherever I go, Murphy goes with me
Re: [SQL] converting big int to date
How can i convert bigint to date format. bigint=6169625280
Re: [SQL] converting big int to date
On Mar 24, 2011, at 2:42 AM, Sree wrote: > How can i convert bigint to date format. > > bigint=6169625280 Please explain what;s this value shows. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
