Thanks I did read that when looking into EXECUTE,
which I'd rather not use. As I said, I would rather
not use plpgsql if possible.
All I want to do is 1) pass in some variables, 2)
reference them, and 3) have a working query which 4)
supports SELECTs, and lastly 5) isn't plpgsql but
pg_native syntax.
--- "A. Kretschmer"
<andreas.kretschmer@schollglas.com> wrote:
> am 29.10.2005, um 20:39:23 -0700 mailte Matthew
> Peter folgendes:
> > Could someone help me and give me a basic example
> of
> > how to write a similiar functional function to the
> one
> > below that would use a dynamic table and update a
> > column only if it held a value.
>
>
http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> HTH, Andreas
> --
> Andreas Kretschmer (Kontakt: siehe Header)
> Heynitz: 035242/47212, D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
> === Schollglas Unternehmensgruppe ===
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com