Re: Passing TEXT variable to a function
От
Betsy Barker
Тема
Re: Passing TEXT variable to a function
Дата
Msg-id
20040824172859.62ccaf9c.betsy.barker@supportservicesinc.com
Ответ на
Re: Passing TEXT variable to a function (Tom Lane)
Список
Дерево обсуждения
Passing TEXT variable to a function Betsy Barker <betsy.barker@supportservicesinc.com>
Re: Passing TEXT variable to a function Tom Lane <tgl@sss.pgh.pa.us>
Re: Passing TEXT variable to a function Josh Berkus <josh@agliodbs.com>
Re: Passing TEXT variable to a function Tom Lane <tgl@sss.pgh.pa.us>
Re: Passing TEXT variable to a function Betsy Barker <betsy.barker@supportservicesinc.com>
quote_literal() worked. Thank you both!
On Tue, 24 Aug 2004 17:33:08 -0400
Tom Lane wrote:
> Josh Berkus 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
В списке pgsql-novice по дате отправления
