Re: plpgsql dynamic queries and optional arguments

From: Curtis Scheer <Curtis(at)DAYCOS(dot)com>
To: "Harvey, Allan AC" <HarveyA(at)OneSteel(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql dynamic queries and optional arguments
Date: 2006-08-16 19:36:44
Message-ID: 031936836C46D611BB1B00508BE7345D049DB67A@gatekeeper.daycos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Allan,

Thanks for the reply I guess what I am actually looking for is an example of
a dynamic SQL select statement similar to how a static sql select can select
into a variable.

Thanks,
Curtis

Curtis,

Here is an example function that uses dynamic sql.
I use it under 7.4.5

Hope this helps.

Allan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-08-16 19:48:50 Re: [NOVICE] DB insert Error
Previous Message Jasbinder Bali 2006-08-16 18:42:46 Re: [NOVICE] DB insert Error