On Thu, 30 Mar 2006 10:45:20 +1100, "Harvey, Allan AC" <HarveyA@xxxxxxxxxxxx> wrote:
> Hi all,
>
> Can sombody please help me realise a function, the intent as described by...
>
> -- Function to create the table for a new point
>
> CREATE OR REPLACE FUNCTION make_table( varchar ) RETURNS VARCHAR AS '
> CREATE TABLE $1(
> parameter varchar(8) NOT NULL,
> value float NOT NULL,
> dt timestamp NOT NULL
> );
execute ''create table ''||quote_ident($1)||'' (...)'';
> CREATE INDEX $1_dtindex ON $1( dt );
execute ''create index ''||quote_ident($1)||''_dtindex ...'';
> SELECT $1;
return $1;
> ' LANGUAGE SQL;
' language plpgsql;
quote_ident function should help with sql insertion attack.
klint.
+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@xxxxxxxxxxxxxx : 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 : :
+---------------------------------------+-----------------+
