Hi,
I have a problem with quoting in one of my functions:
now TIMESTAMP := ''now'';
FOR myRec IN SELECT * FROM myTable WHERE job_end + ''360 Min'' > now LOOP
I want to replace the 360 with the contents of a passed value
but for some reason I can't quote it. ... job_end + ''$1 Min'' does not
work.
Could anyone help me out here ?
On the subject:
The whole quoting in PLPGSQL seems to create many people a headache...
is there any plan to make it a bit more user friendly?
Thanks
Alx