Re: [RFC] Add an until-0 loop in psql
| От | Corey Huinker |
|---|---|
| Тема | Re: [RFC] Add an until-0 loop in psql |
| Дата | |
| Msg-id | CADkLM=fDN3eTJxp-N3vbaJ3WaJi5QO0O3VuMjyJqv5BobtRQ_A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [RFC] Add an until-0 loop in psql (Pavel Stehule <pavel.stehule@gmail.com>) |
| Ответы |
Re: [RFC] Add an until-0 loop in psql
|
| Список | pgsql-hackers |
I did it too. It is not too hard - there was not a agreement on syntax.can be nice some like CTEWITH PROCEDURE x(a int, b int) AS ... $$ SELECT x(10);
I've seen "WITH function...." syntax in Oracle (here's an example: https://oracle-base.com/articles/12c/with-clause-enhancements-12cr1) , but I can see where we'd run into trouble with SELECT statements being atomic, and the PROCEDURE being transactional. If we only allowed a one-line SELECT that problem would go away, but that raises the question of whether SELECT is the right keyword for the job. Is there something in the SQL standard for that?
Either way, we're clearly talking about something to add to postgres, not psql itself, and we should split this conversation to another thread. Sorry for hijacking your thread, Pierre.
В списке pgsql-hackers по дате отправления: