calls - Search results in mailing lists

2024-12-08 14:38:53 | What is the best way to do this in Postgres (kunwar singh)

CALL process_product(curdate, region, productid=>1) ; CALL process_product(curdate, region, productid=>2) ; CALL

2024-09-14 02:06:11 | PostgreSQL implicitly double-quoting identifier name with umlaut (Michael Downey)

called Örtschaft. We anticipated it would be folded to lower case. So we inserted our metadata

2024-05-01 23:08:33 | One parent record with 3 possible child records (JORGE MALDONADO)

called "type" with the following possible values: "residential", "industrial" and "energy". I will always insert

2024-04-05 19:21:10 | Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function (Tom Lane)

like NEW's fault. You lack a suitable function to be called. regards, tom lane

2024-03-25 15:43:11 | Get error when calling function that returns a table (Russell Rose | Passfield Data Systems)

calls a function (test_rr.sql) which returns a table. I use the SQL: Call

2024-03-13 14:30:44 | Re: Nested loop behaviour with pg_stat_activity (Tom Lane)

call pg_stat_clear_snapshot(). Without this behavior you would get total garbage from queries

2024-02-07 17:50:07 | Re: POSTGRES 15 - CONSTRAINT TRIGGER CREATION (Steve Midgley)

calling them from the trigger (with the appropriate parameters) would work.. I hope this

2024-01-09 08:23:49 | Problem with refcursor (Maximilian Tyrtania)

calling the outer one like this: select * from f_client_get3rdFeedbacksuccessrate(); results in: Query 1 ERROR

2024-01-09 08:15:17 | How to use one function which can be accessed for all schemas (intmail01)

call the function and error occurs : "No function matches the given name and argument types

2023-09-18 06:49:01 | RE: no_data_found oracle vs pg (Jean-Marc Voillequin (MA))

called from a PL/pgSQL block, and I want the function to return a NULL value

2023-07-14 06:38:34 | Memory allocation error (Shaozhong SHI)

called in a loop. Sometime, there is an error. sqlstate: XX000 NOTICE: message: invalid memory

2023-07-13 15:11:15 | RE: Can we set time exception? (Voillequin, Jean-Marc)

calls function to work? Can we set a time exception? If the function responds with

2023-07-06 21:54:46 | Re: How do Exception, do nothing and carry on (David G. Johnston)

failure and throws it away, then call that function instead. [1] https:///docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING David J.

2023-06-22 23:07:21 | Re: Strange update behaviour (ProfiVPS Support)

called by CollectD to insert values into a table, and part of it is to update

2023-02-25 21:04:02 | Take the data from table and rotate the member on every 7th day or starting (nikhil raj)

called crew_details [image: enter image description here] There is a requirement to rotate