Hi Richard,
as for the timestamp, both ways work fine, but the other problem still
exists. using a
''60 Min'' works just fine, but WHERE job_end + ($1::text || '' Min'' )
> now
does not. job_end is timestamp without tz
Alex
Richard Huxton wrote:
>On Thursday 06 November 2003 04:13, Alex wrote:
>
>
>>Hi,
>>I have a problem with quoting in one of my functions:
>>
>>now TIMESTAMP := ''now'';
>>
>>
>
>Your main question has been answered, but you might want now() rather than
>''now''. Off the top of my head, I think the ''now'' might get compiled as a
>value on the first run and stay at that value.
>
>
>