On lau, 2008-07-12 at 14:45 +0530, Anoop G wrote:
> Hai Kretschmer ,
>Thanks for your reply, it help to solve my problem. I have few for
> doubts regarding dynamic query
...
> vchr_query:= 'SELECT mf,sf,(mf – mf * comm /100) – (sf – sf *
> comm/100) as flt_claim';
the '–' characters here proba
Hai Kretschmer ,
Thanks for your reply, it help to solve my problem. I have few for doubts
regarding dynamic query
I have a table structure:
Column | Type | Modifiers
+--+---
mf | double precision |
sf | double precision |
comm | inte
am Thu, dem 10.07.2008, um 18:25:38 +0530 mailte Anoop G folgendes:
> my problems are:
>
> 1 problem : in RAISE NOTICE query string is print like this,
>
> How i can put the dates in single quote in a dynamic query string?
Use more quotes *g*:
Example:
test=*# create or replace function my_fo
Hello
why you do use dynamic query?
your function is little bit ugly
a)
create or replace function ..(date_from date, date_to date)
returns setof record as $$
declare r record;
begin
for r in select .. from tbl_ticket where dat_ticket_issue between
date_from and date_to loop
...
b) for s
