On Sunday, February 18, 2024, Laura Smith < n5d9xq3ti233xiyif...@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.
