ame) function.
Date: Sun, 2 Nov 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, rohtode
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 ) ] ) funct
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 A
on if I want a implicit
conversion?
Best Regards,
rohtodeveloper
> 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
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
-
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 t
