On 24 Jan 2007 00:21:44 +0100, Harald Fuchs <[EMAIL PROTECTED]> wrote:
In article <[EMAIL PROTECTED]>,
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> can anybody think of of a way to sneak these into dollar quoted
> strings for substitution into create function?
Can't you put the psql call into a shell script and use shell variable
substitution for that?
right. that works, actually I was using gcc to preprocess my sql
files. This has some side benefits: with a little work you can
actually have C code (or php or whatever) and sql scripts share a
common header, but you can no longer paste sql into psql which is
basically how I like to develop.
psql variables sidestep that tradeoff but are not usable inside
function definitions which is a critical drawback. This is on top of
the fact that create function takes a string but not a string
expression, so you can't run translate() and the like on it.
I'm wondering if I can use some tricky variable substition using sed
or something similar but I'm drawing a blank at the moment.
merlin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
