Re: function example?

From: Matthew Peter <survivedsushi(at)yahoo(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: function example?
Date: 2005-10-30 19:09:16
Message-ID: 20051030190916.43513.qmail@web35214.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)kretschmer(at)schollglas(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-10-30 19:17:53 Re: Oracle 10g Express - any danger for Postgres?
Previous Message Martijn van Oosterhout 2005-10-30 19:05:09 Re: Please HELP - URGENT - transaction wraparound error