Re: [GENERAL] Character escape in "CREATE FUNCTION ..."

2004-03-15 Thread Shilong Stanley Yao
Tom Lane wrote: Shilong Stanley Yao <[EMAIL PROTECTED]> writes: I am trying to write a function in Postgresql, which takes 2 floats and returns a box. But seems the nested single-quote in the AS clause prevent $1 and $2 from being expanded. Besides writing a C function instead of a SQL one, is

Re: [GENERAL] Character escape in "CREATE FUNCTION ..."

2004-03-15 Thread Richard Huxton
On Monday 15 March 2004 18:38, Shilong Stanley Yao wrote: > Dear All, > I am trying to write a function in Postgresql, which takes 2 floats and > returns a box. But seems the nested single-quote in the AS clause > prevent $1 and $2 from being expanded. Besides writing a C function > instead of a

[GENERAL] Character escape in "CREATE FUNCTION ..."

2004-03-15 Thread Shilong Stanley Yao
Dear All, I am trying to write a function in Postgresql, which takes 2 floats and returns a box. But seems the nested single-quote in the AS clause prevent $1 and $2 from being expanded. Besides writing a C function instead of a SQL one, is there any way to solve this problem? Thanks a lot. -S