Dear Hackers
When I use the pg_catalog.char(integer) function in the postgres, I can only
use it like these:select pg_catalog.char(65); select char(65);
But I want to use the function by the following way.select char(1);Of coures,
There would be a gram error.
I know the error is caused by
Hi,all
I have a question about data type timestamp with time zone.
Why data of timestamptz does not store value of timezone passed to it?
Considering the following example.
postgres=# select '2014-08-28 14:30:30.423602+02'::timestamp with time zone;
timestamptz
On 08/29/2014 04:59 AM, Kevin Grittner wrote:
I just took a quick look at the spec to refresh my memory, and it
seems to require that the WITH TIME ZONE types store UTC (I suppose
for fast comparisons), it requires the time zone in the form of a
hour:minute offset to be stored with it, so you
?
Best Regards,
rohtodeveloper
Dear
I'm doing a job about converting an expression of one data type to another.In
SQLServer, there'are two functions to do this job.
1. CAST ( expression AS data_type [ ( length ) ] )2. CONVERT ( data_type [ (
length ) ] , expression )
However, In PostgreSQL, there's only the CAST ( expression
Dear
In SQLServer, there'are two functions to converte an expression of one data
type to another.
1. CAST ( expression AS data_type [ ( length ) ] )2. CONVERT ( data_type [ (
length ) ] , expression )
However, In PostgreSQL, there's only the CAST ( expression AS data_type [ (
length ) ] )
2014 16:00:14 +05
Subject: Re: [HACKERS] How to implent CONVERT ( data_type [ ( length ) ] ,
expression ) function in postgreSQL
From: atri.j...@gmail.com
To: rohtodevelo...@outlook.com
CC: pgsql-hackers@postgresql.org
On Sun, Nov 2, 2014 at 3:40 PM, rohtodeveloper rohtodevelo...@outlook.com