am Fri, dem 08.06.2007, um 9:46:14 -0700 mailte Gary Townsend folgendes:
> CREATE OR REPLACE FUNCTION vts_insert_stop(text, text, numeric, numeric,
> numeric)
>
> RETURNS numeric AS
>
> '
>
> BEGIN
>
> SELECT INTO transCoord X(SubSel.transformed_geom), Y
> (SubSel.transformed_geom) FROM (
>
> SELECT SetSRID(
>
> Transform(
>
> GeomFromText(
>
> ''POINT('' || stopeasting || '' '' stopnorthing || '')'',
> projection
If you want to call dynamicaly created sql-statements you need to use
EXECUTE.
http://www.postgresql.org/docs/current/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net