time dates - Search results in mailing lists
Mailing lists >> pgsql-novice >> Thread
2024-02-26 15:40:53 | Re: Reset date for Cumulative Statistics System when not in table (Laurenz Albe)
On Mon, 2024-02-26 at 14:47 +0100, blockdump wrote: Statistics survive a restart
Mailing lists >> pgsql-novice >> Thread
2023-10-07 14:38:30 | Re: Is `DATE` a function? (Tom Lane)
date | timestamp with time zone | func pg_catalog | date | date | timestamp without time zone | func
Mailing lists >> pgsql-novice >> Thread
2023-06-05 15:15:24 | Re: Does PostgreSQL cache all columns of a table after SELECT? (Tim Schwenke)
time, the full file / segment is read and put into page cache if there is enough space. Pages are subsegment. You may also wish to take care to notice the version of documentation pages
Mailing lists >> pgsql-novice >> Thread
2023-03-26 15:36:58 | Re: How to get column, table or parameter name reporting when violating DOMAIN type constraint (David G. Johnston)
dates or numbers. Sure, that added context is not always applicable but when it is the lack of error detail does make life hard. But it isn’t an easy problem to solve either. There
Mailing lists >> pgsql-novice >> Thread
2021-11-12 20:54:42 | Re: Regclass what does reg mean (Tom Lane)
time --- regproc dates back to Berkeley times, and the rest of those were named on its precedent
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2021-11-06 19:11:32 | Specified date type but created column is timestamp without time zone (Mike Elston)
date | *timestamp without time zone* | | | According to https:///docs/9.1/datatype-datetime.html date is a distinct type occupying
Mailing lists >> pgsql-novice >> Thread
2021-06-04 14:04:40 | Re: NOW() function in combination with SET timezone (Tom Lane)
time in UTC.) Later, if you try to read out the value, the value is converted to a string according to the then-prevailing timezone setting. Internal operations like now() and comparisons are unbothered
Mailing lists >> pgsql-novice >> Thread
2021-01-26 15:15:54 | Not able to restore generated columns due to a function (Santosh Udupi)
date_time timestamptz GENERATED ALWAYS AS (task_completed_date(info->>'dd', info->>'qq', info->>'dp', info
Mailing lists >> pgsql-novice >> Thread
2021-01-21 13:51:26 | Re: Postgres 12 - Generated Columns - Backup/Restore (Santosh Udupi)
date_time timestamptz GENERATED ALWAYS AS (task_completed_date(info->>'dd', info->>'qq', info->>'dp', info
Mailing lists >> pgsql-novice >> Thread
2020-09-29 00:33:46 | Re: [EXT] Re: NOTIFY (Greg Rychlewski (LCL))
Date: Monday, September 28, 2020 at 8:07 PM
To: "Greg Rychlewski (LCL)"
Mailing lists >> pgsql-novice >> Thread
2020-04-30 17:27:04 | ON CONFLlCT DO UPDATE command cannot affect row a second time (cryptodactyl)
time HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values. Here is the code part: def update_tbl(job): """ Try to insert new record into the table
Mailing lists >> pgsql-novice >> Thread
2020-02-08 22:43:46 | RE: Where condition doesn't work as expected (Ken Benson)
value to a timestamp. [Ken.B] SELECT to_date('20170103','YYYYMMDD'); https:///postgresql-to_date/ Thanks for your time. William.
Mailing lists >> pgsql-novice >> Thread
2019-12-16 00:38:40 | QueryTime (Zahid Rahman)
date")); conn.close(); } catch (Exception e){ System.out.println(e);} long End = System.currentTimeMillis(); System.out.println(" query time
Mailing lists >> pgsql-novice >> Thread >> Search in thread (4)
2019-06-12 13:27:04 | Re: Error when doing sql (Cravan)
Date: Wednesday, 12 June 2019 at 9:25 PM
To: cool kid
Mailing lists >> pgsql-novice >> Thread >> Search in thread (3)
2019-05-20 18:44:25 | Fwd: What version postgresql libpqxx (Gavin M2301)
time as 11.0 so I will go with probably 11.3 and 7.0.
Thnx. Roboloki
---------- Forwarded message ---------
From:Gavin M2301