Tom Lane <tgl@sss.pgh.pa.us> writes:
> chestie <mcit@argus.net.au> writes:
>> I kept getting this same error, heres what I was trying to do.
>
>> it := select int4(extract(epoch from timestamp $1 -
>> extract(epoch from timestamp $2));
>
> You should just write
>
> it := select int4(extract(epoch from $1) -
> extract(epoch from $2));
It works (without the select, my fault).
> You are confusing the syntax
I'm just confused in general. :)
Thanks for the explanation.