Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> chestie <mcit(at)argus(dot)net(dot)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.