Re: [GENERAL] Select Command in Procedures

2011-02-03 Thread hubert depesz lubaczewski
On Thu, Feb 03, 2011 at 02:26:10PM +0530, Adarsh Sharma wrote: > globe=# CREATE FUNCTION user10() RETURNS void AS' > globe'# DECLARE > globe'# BEGIN > globe'# create table user_news_new as select > record_id,field_name,field_value,news_date from user_news where > field_name in ('SOI','RelLoc','Desc

[GENERAL] Select Command in Procedures

2011-02-03 Thread Adarsh Sharma
Dear all, I am able to execute command successfully through CLI or pgAdmin . *create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ; * But I don't know wh