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@xxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
