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

[Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx>]

> 
> There's not bespoke SQL syntax for constructing a range. You must
> use a function, something like
> 
> VALUES(p_event_id, tstzrange(p_start_time,p_end_time,'[)')) ...


Thanks all for your swift replies.

Serves me right for assuming I could use variable substitution where text would normally go, i.e. I thought I could just mimic the below example from the docs by substituting the variables:

INSERT INTO reservation VALUES
    (1108, '[2010-01-01 14:30, 2010-01-01 15:30)');

Lesson learnt !

Thanks again.