Re: PGPLSql Select Into problem.

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PGPLSql Select Into problem.
Date: 2007-06-09 08:48:49
Message-ID: 20070609084849.GA28881@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2007-06-09 12:27:19 Re: PGPLSql Select Into problem.
Previous Message David Gardner 2007-06-08 18:20:54 current_date and pl/pgsql volitility