Re: Help to realise function - Mailing list pgsql-general

From Klint Gore
Subject Re: Help to realise function
Date
Msg-id 4430AF30372.C322KG@129.180.47.120
Whole thread Raw
In response to Help to realise function  ("Harvey, Allan AC" <HarveyA@OneSteel.com>)
List pgsql-general
On Mon, 3 Apr 2006 14:57:14 +1000, "Harvey, Allan AC" <HarveyA@OneSteel.com> wrote:
> Hi all,
>
> Can anyone offer suggestions on how to realise this function....
>
> It is the $1 as the table name that is the problem.
>
> I'm using Version 7.4.5
>
> create or replace function last_scan( varchar, varchar ) returns float as '
>     declare
>         result float;
>
>     begin
>         result := value from $1 where parameter = $2 order by dt desc limit 1;
>
>         return result;
>     end;
> ' LANGUAGE plpgsql;

try executing the query

declare
    r record;
begin
    for r in execute 'select value from '||quote_ident($1)||' where
    parameter = '||quote_literal($2)||' order by dt desc limit 1' loop
        return r.value;
    end loop;
    return null;
end;

klint.

+---------------------------------------+-----------------+
: Klint Gore                            : "Non rhyming    :
: EMail   : kg@kgb.une.edu.au           :  slang - the    :
: Snail   : A.B.R.I.                    :  possibilities  :
: Mail      University of New England   :  are useless"   :
:           Armidale NSW 2351 Australia :     L.J.J.      :
: Fax     : +61 2 6772 5376             :                 :
+---------------------------------------+-----------------+

pgsql-general by date:

Previous
From: "Harvey, Allan AC"
Date:
Subject: Help to realise function
Next
From: Tino Wildenhain
Date:
Subject: Re: PostgreSQL's XML support comparison against other RDBMSes