Re: psql: add \create_function command

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: psql: add \create_function command
Дата
Msg-id CAFj8pRDrg2a=2vRDn=gaWENUHZxubK_mP8MPX6twHR=6NdYPMw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql: add \create_function command  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: psql: add \create_function command
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Report planning memory in EXPLAIN ANALYZE
Следующее
От: Alvaro Herrera
Дата:
Сообщение: meson + libpq_pipeline