Re: Problems with question marks in operators (JDBC, ECPG, ...)

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Problems with question marks in operators (JDBC, ECPG, ...)
Дата
Msg-id CAKFQuwag-AAxXVcCatpkYjegwpsYAkeFKL_spuXsfs_8rWjABQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problems with question marks in operators (JDBC, ECPG, ...)  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Problems with question marks in operators (JDBC, ECPG, ...)  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-hackers
Дерево обсуждения
On Sun, May 17, 2015 at 9:15 AM, Greg Sabino Mullane <greg@turnstep.com> wrote:
Dave Cramer wrote:
> Well our solution was to use ?? but that does mean we have to do some
> extra parsing which in a perfect world wouldn't be necessary.

That's not a good solution as '??' is a perfectly valid operator. ISTR
seeing it used somewhere in the wild, but I could be wrong.


​It which case you would write (I think, not tested and not part of the test suite that I can see...):

a ???? b ...

​There was some discussion about ?? vs \?:

https://github.com/pgjdbc/pgjdbc/pull/187

I did find some alternatives discussed a couple of years back, like {postgres qm} and <operator("?")>; the later simply being to allow the operator to be quoted inside "operator()"

​http://postgresql.nabble.com/Alias-hstore-s-to-so-that-it-works-with-JDBC-td5743863i20.html

​The commit that added "??":

​https://github.com/pgjdbc/pgjdbc/pull/227

David J.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: WALWriteLock contention
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: jsonb concatenate operator's semantics seem questionable