*Regards,*
*Rajin *
On Thu, Jun 4, 2020 at 7:23 PM Tom Lane wrote:
> Rajin Raj writes:
> > Option 1: AT TIME ZONE 'IST'
> > Option 2: AT TIME ZONE 'Asia/Kolkata'
> > In the first option, I get +2:00:00 offset (when *timezo
Hi ,
What is the right approach for using AT TIME ZONE function?
Option 1: AT TIME ZONE 'IST'
Option 2: AT TIME ZONE 'Asia/Kolkata'
In the first option, I get +2:00:00 offset (when *timezone_abbrevations =
'Default'*) and for option 2 , +5:30 offset.
I can see multiple entries for IST in pg_t
Hi,
Is there way to insert the cron job execution status to a table?
Or any other method to identify the job status without checking the log
file?
*Regards,*
*Rajin *
Is there any impact of using the character varying without providing the
length while creating tables?
I have created two tables and inserted 1M records. But I don't see any
difference in pg_class. (size, relpage)
create table test_1(name varchar);
create table test_2(name varchar(50));
insert in
--> Function ' filter_id ' filters the ID's based on some conditions.
--> Input is set of ID's. (Not directly taking the input since there is no
provision to pass multiple rows to a function)
create function filter_id()
return table (id bigint)
begin
--> Assuming input table is already created #t
Hi,
I'm trying to convert SAP Hana procedures in PG and i'm not able to handle
below scenario in Postgres 11
Scenario: I want to pass a table (Multiple rows) to function and use it
inside as a temp table.
Sample Code:
create a table tbl_id (id int, name character varying (10));
insert few rows
I'm trying to convert SAP Hana procedures in PG and i'm not able to handle
below scenario in Postgres 11
Scenario: I want to pass a table (Multiple rows) to function and use it
inside as a temp table.
Sample Code:
create a table tbl_id (id int, name character varying (10));
insert few rows to tb
