Re: Stored procedure - Mailing list pgsql-general

From Thorsten Kraus
Subject Re: Stored procedure
Date
Msg-id 4639FF57.5050901@gmx.de
Whole thread Raw
In response to Re: Stored procedure  ("Hakan Kocaman" <Hakan.Kocaman@digame.de>)
Responses Re: Stored procedure
List pgsql-general
Hi,

thanks for your answer, but I don't get the point. Perhaps you can give
me a small example how to get the EXECUTE into a stored procedure.

Regards

Hakan Kocaman schrieb:
> Hi,
>
> Try EXECUTE
> http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> Best Regards
>
> Hakan Kocaman
> Software-Development
>
> digame.de GmbH
> Richard-Byrd-Str. 4-8
> 50829 Köln
>
> Tel.: +49 (0) 221 59 68 88 31
> Fax: +49 (0) 221 59 68 88 98
> Email: hakan.kocaman@digame.de
>
> digame.de GmbH, Sitz der Gesellschaft: Köln, Handelsregister Köln, HRB 32349
> Geschäftsführung: Werner Klötsch, Marco de Gast
>
>
>
> ________________________________
>
>     From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thorsten Kraus
>     Sent: Thursday, May 03, 2007 5:00 PM
>     To: pgsql-general@postgresql.org
>     Subject: [GENERAL] Stored procedure
>
>
>     Hi NG,
>
>     I want to write a stored procedure which creates a table in my PostgreSQL database. The procedure has one input
parameter:the table name. 
>     Here is my first try, but that does not work:
>     --------------------------------------------------------------------------------------------------
>
>     CREATE OR REPLACE FUNCTION create_geom_table(text) RETURNS void AS $$
>     DECLARE
>         --table_name TEXT;
>     BEGIN
>     ---------------------------------------
>     CREATE TABLE table_name
>     (
>       id integer,
>       "time" timestamp without time zone,
>       geom geometry,
>       CONSTRAINT enforce_dims_geom CHECK (ndims(geom) = 2),
>       CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'MULTIPOLYGON'::text OR geom IS NULL),
>       CONSTRAINT enforce_srid_geom CHECK (srid(geom) = -1)
>     )
>     WITHOUT OIDS;
>     ALTER TABLE table_name OWNER TO "admin";
>
>     CREATE INDEX geo_index ON table_name USING gist(geom);
>
>     ---------------------------------------
>     ALTER FUNCTION create_geom_table(table_name) OWNER TO "admin";
>     END;
>     $$ LANGUAGE plpgsql;
>
>     --------------------------------------------------------------------------------------------------
>
>     Can someone tell me what's wrong with this and what I have to change?
>
>     Regards,
>     Thorsten
>
>
>


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Update violating constraint
Next
From: Matthew Hixson
Date:
Subject: varchar as primary key