Re: Function inserting into tstzrange ? (syntax error at or near...)

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Function inserting into tstzrange ? (syntax error at or near...)
Дата
Msg-id CAKFQuwZsjAv56H-vx1KAUEuvYP_uu+FOfznERn5kzG_7YSe50w@mail.gmail.com
обсуждение исходный текст
Ответ на Function inserting into tstzrange ? (syntax error at or near...)  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
Список pgsql-general
Дерево обсуждения
On Sunday, February 18, 2024, Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch> wrote:
I'm sure I'm doing something stupid here, but I think I've got the syntax right ?

The error I'm seeing:
psql:event_session_funcs.sql:26: ERROR:  syntax error at or near "["
LINE 11:         VALUES(p_event_id,[p_start_time,p_end_time)) RETURNI...


It’s telling you you have a syntax error so no you’ve don’t have the syntax right.

The [ and ) used to describe the bound inclusiveness of the range must appear in a string literal, I.e.  enclosed in single quotes.

The functional constructors for ranges allow you to specify a single string literal containing both as the third argument.

David J.

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

Предыдущее
От: Laura Smith
Дата:
Сообщение: Function inserting into tstzrange ? (syntax error at or near...)
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Function inserting into tstzrange ? (syntax error at or near...)