throw date - Search results in mailing lists
Mailing lists >> pgsql-general >> Thread >> Search in thread (3)
2025-04-18 23:27:27 | Re: [EXTERNAL] Re: Why is an error not thrown when the time exceeds the lock (Mansky, Edmund J. (GSFC-671.0)[ADNET Affiliate]" )
Date: Friday, April 18, 2025 at 11:51 AM
To: "Mansky, Edmund J. (GSFC-671.0)[ADNET Affiliate]"
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2024-09-01 07:33:21 | Re: Partitioning and unique key (veem v)
date+timestamp values as we cant throw those values away per business need, so we will
Mailing lists >> pgsql-general >> Thread
2024-08-13 04:27:11 | Re: Problem with a Query (Tom Lane)
throwing away 99.8% of those rows. Probably, using an index on (status_id, followup_date
Mailing lists >> pgsql-general >> Thread
2024-07-06 21:29:12 | Declaring a field that is also an out parameter in a function (Michael Nolan)
date; END $$ language 'plpgsql'; Here's what happens in 16.1: psql (16.1) Type "help" for help. uscf=> select test_function('1234','a','2024-01-01') uscf-> \g test_function ---------------------------- ("foo,bar",15,,2024
Mailing lists >> pgsql-general >> Thread
2024-06-30 22:39:26 | Passing a dynamic interval to generate_series() (Igal Sapir)
date + interval '7 month'), interval '1 month' ) This works as expected and returns an interval of 1 month: SELECT ('1 ' || 'month')::interval; But this throws
Mailing lists >> pgsql-general >> Thread
2024-02-04 15:30:08 | Re: How to do faster DML (Lok P)
throw some light on the compression strategy which we should follow here (considering a daily range partition table based on transaction_date
Mailing lists >> pgsql-general >> Thread
2023-02-27 19:10:33 | Tempory table is not getting created inside Function in postgres. (nikhil raj)
DATE, LINE_POSITION ASC$BODY$; ALTER FUNCTION api."post_publish_Roster"() OWNER TO postgres; GRANT EXECUTE ON FUNCTION api."post_publish_Roster"() TO PUBLIC; GRANT EXECUTE ON FUNCTION api."post_publish_Roster"() TO postgres; GRANT
Mailing lists >> pgsql-general >> Thread
2022-10-17 05:17:31 | 回复：回复：A question about leakproof (qiumingcheng)
date_v1) execution plan are different under different users, which is really related to the parameter proleakproof. If the 2 below is changed to 'return true' , the execution plan will be indexscan ------------------------------------------------------------------ 发件人：Tom Lane
Mailing lists >> pgsql-general >> Thread
2022-05-10 04:28:35 | Question on cast string to date (正华吕)
date_in to do the cast, and firstly use last 2 chars to get the day, and the 2 chars to get the month, and all remaining chars as year. The question here is: should
Mailing lists >> pgsql-general >> Thread
2021-08-19 14:37:27 | Selecting table row with latest date (Rich Shepard)
date. The Comparison Date/Time sections in the postgres 12 doc doesn't appear to have what I want, and when I try to use the max() aggregate function it throws
Mailing lists >> pgsql-general >> Thread
2020-11-25 16:43:20 | RE: INSERT Trigger to check for existing records : Does this do what I hope it ()
throw a rod. I don't actually need to return anything as the goal of the FUNCTION (for the moment) is to perform updates to a table. It might be nice to return some sort
Mailing lists >> pgsql-general >> Thread
2020-03-31 17:52:27 | streaming slaves can't keep up? (Ben Chobot)
date. But the replay_location on those busy slaves falls behind by quite a lot (over an hour behind), and this is a problem. On the slaves which aren't taking client load, their replay
Mailing lists >> pgsql-general >> Thread
2019-08-27 18:51:39 | Re: No warning/error trying to vacuum other session's temp table (Tom Lane)
date on disk. (We don't throw a * warning here; it would just lead to chatter
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2019-03-21 07:11:18 | SV: to_timestamp function (Gustavsson Mikael)
date('2009-06-40','YYYY-MM-DD') would return '2009-07-10' because there was no prohibition on out-of-range month or day numbers. This has been widely panned, and it also turns
Mailing lists >> pgsql-general >> Thread
2019-01-04 22:21:42 | Immutable way to cast timestamp TEXT to DATE? (for index) (Ken Tanzer)
date, etc.), but all of them throw the error "functions in index expression must be marked