Postgres Pro
Downloads
Home   >   mailing lists

Problems with PLPGSQL - Mailing list pgsql-general

From Alex
Subject Problems with PLPGSQL
Date
Msg-id 3FA9CA4C.7020904@meerkatsoft.com
Whole thread Raw
Responses Re: Problems with PLPGSQL  (Jason Godden <jasongodden@optushome.com.au>)
Re: Problems with PLPGSQL  (Richard Huxton <dev@archonet.com>)
Re: Problems with PLPGSQL  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL v7.4 Release Candidate 1 compile errors
Next
From: Jason Godden
Date:
Subject: Re: Problems with PLPGSQL