Skip site navigation (1) Skip section navigation (2)

Re: execute dynamic strings

From: brew(at)theMode(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: execute dynamic strings
Date: 2005-02-22 22:28:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

> I have a function with 3 parameters (select clause, where clause and
> order by clause (last two are optionally clauses). This clauses apply to
> a given

> I know I must use execute and prepare syntax, but I don't know how to
> create the function.

Is this a postgreSQL function you've written or are you planning on using
an external language like perl or php?

It would be helpful if you posted a code snippet that you've tried.


                  Strange Brew   (brew(at)theMode(dot)com)
  Check out my Stock Option Covered Call website
     and my Musician's Online Database Exchange

In response to

pgsql-novice by date

Next:From: John NapiorkowskiDate: 2005-02-23 06:11:24
Subject: Support for RETURNING xxx INTO yyy for INSERT and UPDATE?
Previous:From: brewDate: 2005-02-22 22:00:16
Subject: Re: Perl DBI connection to Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group