| From: | Betsy Barker <betsy(dot)barker(at)supportservicesinc(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | josh(at)agliodbs(dot)com, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Passing TEXT variable to a function |
| Date: | 2004-08-24 23:28:59 |
| Message-ID: | 20040824172859.62ccaf9c.betsy.barker@supportservicesinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
quote_literal() worked. Thank you both!
On Tue, 24 Aug 2004 17:33:08 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
> > Aha, syntax error, you forgot the nested quotes:
>
> > FOR getpercentiles IN EXECUTE ''SELECT * FROM get_facility_percentiles(''''''
> > || wagerateid_list || '''''')'' LOOP
>
> She really wants quote_literal(), instead, so that the function doesn't
> break if someone passes a value that contains quotes ...
>
> regards, tom lane
>
--
Betsy Barker
IT Manager
Support Services, Inc
(720)489-1630 X 38
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hisashi Wakai | 2004-08-24 23:30:40 | Re: What to download?!! (MacOS X) |
| Previous Message | Betsy Barker | 2004-08-24 22:08:15 | Passing TEXT variable to a function |