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.
