Re: psql: add \create_function command - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: psql: add \create_function command
Date
Msg-id CAFj8pRDrg2a=2vRDn=gaWENUHZxubK_mP8MPX6twHR=6NdYPMw@mail.gmail.com
Whole thread Raw
In response to Re: psql: add \create_function command  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql: add \create_function command
List pgsql-hackers


po 29. 1. 2024 v 18:11 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Steve Chavez <steve@supabase.io> writes:
> However, :{?variable_name} is already taken by psql to test whether a
> variable is defined or not. It might be confusing to use the same syntax.

Hmm.  Maybe we could go with :{+...} or the like?

> How about using the convention of interpreting an identifier as a file path
> if it has an slash on it?

Sorry, that is just horrid.  foo/bar means division, and "foo/bar"
is simply an identifier per SQL standard, so you can't squeeze that
in without breaking an ocean of stuff.  Plus, there are many use-cases
where there's no reason to put a slash in a relative filename.

sometimes paths starts by $ or .

or maybe :{{ ... }}

 

                        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Report planning memory in EXPLAIN ANALYZE
Next
From: Alvaro Herrera
Date:
Subject: meson + libpq_pipeline