Re: function signature allow "default" keyword

Hi út 16. 5. 2023 v 5:11 odesílatel jian he napsal: > > > On Mon, May 15, 2023 at 5:00 PM Thomas Kellerer wrote: > >> jian he schrieb am 15.05.2023 um 10:33: >> > >> > function idea. >> > allow function calling using the default keyword for any of the input >> arguments. >> > >> > example: htt

Re:

On Mon, May 15, 2023 at 11:42 AM Fabrice Chapuis wrote: > I am using postgres v.14 on rhel8 > I enabled the track_commit_timestamp parameter. > > postgres [379418]=# show track_commit_timestamp ; > ┌┐ > │ track_commit_timestamp │ > ├┤ > │ on

Re: function signature allow "default" keyword

On Mon, May 15, 2023 at 5:00 PM Thomas Kellerer wrote: > jian he schrieb am 15.05.2023 um 10:33: > > > > function idea. > > allow function calling using the default keyword for any of the input > arguments. > > > > example: https://dbfiddle.uk/FQwnfdmm > > So something like this "SELECT * FROM cu

Re: Adding SHOW CREATE TABLE

On Fri, May 12, 2023 at 8:37 PM Stephen Frost wrote: > Greetings, > ... > Yes, it's a large effort, no doubt. > > Stephen, I started looking at the code. And I have the queries from \set SHOW_HIDDEN that psql uses. And also the pg_dump output. My first table was an ID bigint NOT NULL PRIMARY K

xid type? (was :)

> On May 15, 2023, at 08:41, Fabrice Chapuis wrote: > What is the xid type and how can I cast integer value to make > pg_xact_commit_timestamp to work? The xid type is... xid. You'll need to cast as a string instead of an integer: xof=# select pg_xact_commit_timestamp('53013547'::xid); p

[no subject]

I am using postgres v.14 on rhel8 I enabled the track_commit_timestamp parameter. postgres [379418]=# show track_commit_timestamp ; ┌┐ │ track_commit_timestamp │ ├┤ │ on │ └┘ (1 row) I performed a recover

Re: PG_Cron - Error Message Connection failed

Le lun. 15 mai 2023 à 05:12, FOUTE K. Jaurès a écrit : > > > Le dim. 14 mai 2023 à 21:12, Adrian Klaver a > écrit : > >> On 5/14/23 13:04, FOUTE K. Jaurès wrote: >> > >> > >> > Le dim. 14 mai 2023 à 16:12, Adrian Klaver > > > a écrit : >> >> > >> > Not what

Re: function signature allow "default" keyword

jian he schrieb am 15.05.2023 um 10:33: > > function idea. > allow function calling using the default keyword for any of the input > arguments. > > example: https://dbfiddle.uk/FQwnfdmm > So something like this "SELECT * FROM customer_orders(2579927, > 'order_placed_on DESC', default, 2);" > shou

function signature allow "default" keyword

function idea. allow function calling using the default keyword for any of the input arguments. example: https://dbfiddle.uk/FQwnfdmm So something like this "SELECT * FROM customer_orders(2579927, 'order_placed_on DESC', default, 2);" should work.