| 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 14:13:48 |
| Message-ID: | 20070609141348.GA603@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Monarchi | 2007-06-09 18:01:50 | forcing pg to use an index |
| Previous Message | Michael Fuhr | 2007-06-09 12:27:19 | Re: PGPLSql Select Into problem. |