我有一个类似这样的查询 -
select unnest(string_to_array(news_article.news_category_id, ',')):: int rowz
from news_article) where rowz=1;
查询中加入rowz=1导致查询不起作用?如果我只想要rowz=1的结果,该怎么做呢?
当我这样做时-
从新闻文章中选择unnest(string_to_array(na.news_category_id, ','))::int rowz;
我的表格是-
Create table news_article(
id bigserial NOT NULL PRIMARY KEY,
news_headline character varying(70) NOT NULL,
news_content_src character varying(240) NOT NULL,
news_language_id integer NOT NULL,
news_category_id character varying(50) NOT NULL,
news_publisher_id integer NOT NULL references news_publishers(pub_id),
news_date timestamp WITH TIME ZONE Default now()
);
然后它给我这个结果 -
rowz
1
2
1
3
2