Postgres Pro
Downloads
Home   >   mailing lists

Re: PGPLSql Select Into problem. - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: PGPLSql Select Into problem.
Date
Msg-id 20070609141348.GA603@a-kretschmer.de
Whole thread Raw
In response to Re: PGPLSql Select Into problem.  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Tree view 
am  Sat, dem 09.06.2007, um  6:27:19 -0600 mailte Michael Fuhr folgendes:
> On Sat, Jun 09, 2007 at 10:48:49AM +0200, A. Kretschmer wrote:
> > am  Fri, dem 08.06.2007, um  9:46:14 -0700 mailte Gary Townsend folgendes:
> > >             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
>
> This isn't a dynamic SQL statement.  POINT isn't a function; it's

Oh, thanks for the clarification, my fault.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: PGPLSql Select Into problem.
Next
From: "David Monarchi"
Date:
Subject: forcing pg to use an index