PLPGSQL的问题 [英] Problems with PLPGSQL
问题描述
我的一个功能引用时遇到问题:
现在TIMESTAMP:=''''现在'''' ;
for myRec IN SELECT * from myTable WHERE job_end +''''360 Min'''>现在循环
我想用通过值的内容替换360
但由于某种原因我不能引用它。 ... job_end +''''$ 1 Min''''没有
工作。
有人能帮助我吗?
关于这个主题:
PLPGSQL中的整个引用似乎让很多人头疼......
有没有计划让它更多用户友好?
谢谢
Alx
---------- -----------------(广播结束)---------------------------
提示3:如果通过Usenet发布/阅读,请发送适当的
subscribe-nomail命令到 ma ******* @ postgresql.org ,以便您的
消息可以干净地通过邮件列表
Hi,
I have a problem with quoting in one of my functions:
now TIMESTAMP := ''''now'''';
FOR myRec IN SELECT * FROM myTable WHERE job_end + ''''360 Min'''' > now LOOP
I want to replace the 360 with the contents of a passed value
but for some reason I can''t quote it. ... job_end + ''''$1 Min'''' does not
work.
Could anyone help me out here ?
On the subject:
The whole quoting in PLPGSQL seems to create many people a headache...
is there any plan to make it a bit more user friendly?
Thanks
Alx
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
推荐答案
1分钟没有
工作。
任何人都可以帮助我在这里?
关于这个主题:
PLPGSQL中的整个引用似乎让很多人头疼......
有什么计划吗?到m是否更方便用户使用?
谢谢
Alx
---- -----------------------(播出结束)---------------------- -----
提示3:如果通过Usenet发布/阅读,请发送适当的
subscribe-nomail命令给 ma ******* @ postgresql.org ,以便您的
消息可以干净地通过邮件列表
1 Min'''' does not
work.
Could anyone help me out here ?
On the subject:
The whole quoting in PLPGSQL seems to create many people a headache...
is there any plan to make it a bit more user friendly?
Thanks
Alx
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
你好Alex,
如果你想达到''360分钟'作为你将使用的字符串
连接:
FOR myRec IN SELECT * from myTable WHERE job_end +(
Hi Alex,
If you want to achieve say ''360 min'' as the string you will have use
concatenation:
FOR myRec IN SELECT * FROM myTable WHERE job_end + (
1 :: text || '''''''''''''''>
现在LOOP
语法是SQL而不是类似PHP的。
Rgds,
Jason
On Thu,2003年11月6日03:13 pm,Alex写道:
1::text || '''' Min'''') >
now LOOP
The syntax is SQL rather than PHP-like.
Rgds,
Jason
On Thu, 6 Nov 2003 03:13 pm, Alex wrote:
我的一个函数引用有问题:
现在TIMESTAMP:=''''''''';
FOR myRec IN SELECT * FROM myTable WHERE job_end +''''360 Min''''>现在循环
我想用通过值的内容替换360
但由于某种原因我不能引用它。 ... job_end +''''
Hi,
I have a problem with quoting in one of my functions:
now TIMESTAMP := ''''now'''';
FOR myRec IN SELECT * FROM myTable WHERE job_end + ''''360 Min'''' > now LOOP
I want to replace the 360 with the contents of a passed value
but for some reason I can''t quote it. ... job_end + ''''
这篇关于PLPGSQL的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!