Function and Procedure with same signature?

2024-02-09 Thread Deepak M
Hello Hackers, Folks, When tried to create a function with the same signature as procedure it fails. postgres=# create or replace procedure obj1(char) language plpgsql as $$ begin select $1; end; $$; CREATE PROCEDURE postgres=# create or replace function obj1(char) returns void language sql as

Re: A tiny improvement of psql

2023-12-26 Thread Deepak M
On repeating the execution of last command in psql, we can always use below command to send current query buffer to server. \g \gx (with expanded output mode, that always come handy.) On Tue, Dec 26, 2023 at 9:56 PM Kevin Wang wrote: > Hello hackers! > > I am an Oracle/PostgreSQL DBA, I am not