一个简单的数据库查询语句POSTGRES

ZOU_SEAFARER 2008-03-11 09:38:11
SELECT TRIM("fEwcDivision") FROM "TempData_TableC002700" WHERE TRIM("fEwcDivision") <> '' GROUP BY TRIM("fEwcDivision")
数据库:POSTGRES 8.2.5
在数据库管理器中查询数据正常,结果查询出26条非空,且不重复(有效字符非重复,比如“AA”和“AA ”算相同)
但是用在VB语言中提交语句给ODBC处理,结果返回大出所料,全部是NULL(26条)

请高人帮分析分析!
...全文
193 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
ZOU_SEAFARER 2008-03-11
  • 打赏
  • 举报
回复
算了,用了一个比较苯的办法了,先查询出来允许重复的数据(比如“AA”和“AA ”算不相同)但是如果都是空格的记录被筛出,语句如下:
SELECT "fEwcDivision" FROM "TempData_TableC002700" WHERE TRIM("fEwcDivision") <> '' GROUP BY "fEwcDivision"

在使用数据集合的时候再处理处理,吧"AA" 和 "AA " 再比较处理保留"AA"
这样虽然没有发挥数据库优势,好歹也是功能上哒到了,如果有人知道怎么用数据库处理数据,请告诉我,我再去修改查询语句!


ZOU_SEAFARER 2008-03-11
  • 打赏
  • 举报
回复
在POSTGRES中,经过尝试,字段需要引号括起来的!
再说我在pgAdmin3中用同样的语句能得到26条非NULL数据,但是用VB通过ODBC就返回26条NULL数据
ZOU_SEAFARER 2008-03-11
  • 打赏
  • 举报
回复
"fEwc01Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc01DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc02Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc02DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc03Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc03DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc04Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc04DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc05Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc05DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc06Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc06DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc07Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc07DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc08Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc08DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc09Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc09DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc10Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc10DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc11Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc11DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc12Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc12DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc13Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc13DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc14Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc14DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc15Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc15DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc16Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc16DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc17Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc17DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc18Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc18DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc19Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc19DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc20Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc20DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc21Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc21DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc22Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc22DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc23Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc23DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc24Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc24DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc25Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc25DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc26Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc26DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc27Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc27DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc28Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc28DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc29Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc29DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc30Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc30DivPosition" smallint NOT NULL DEFAULT 0,
"fEwcDeleteKbn" character(1) NOT NULL DEFAULT ''::bpchar,
"fEwcMikakunin" integer NOT NULL DEFAULT 0,
"fEwcCreateDate" timestamp without time zone NOT NULL DEFAULT now(),
"fEwcCreateName" character varying(40) NOT NULL DEFAULT ''::character varying,
"fEwcUpdateDate" timestamp without time zone NOT NULL DEFAULT now(),
"fEwcUpdateName" character varying(40) NOT NULL DEFAULT ''::character varying
)
WITHOUT OIDS;
ALTER TABLE "TempData_TableC002700" OWNER TO postgres;
建表代码,没有关键字段,是临时使用的表!
ZOU_SEAFARER 2008-03-11
  • 打赏
  • 举报
回复
不知道为何
效果还是一样!是不是数据库有问题呢??
CREATE TABLE "TempData_TableC002700"
(
"fEwcDatMasID" integer NOT NULL DEFAULT 0,
"fEwcDatNo" integer NOT NULL DEFAULT 0,
"fEwcRow" integer NOT NULL DEFAULT 0,
"fEwcDIA" character varying(2) NOT NULL DEFAULT ''::character varying,
"fEwcPage" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcFR" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcGaiMasID" integer NOT NULL DEFAULT 0,
"fEwcCircuit" character varying(8) NOT NULL DEFAULT ''::character varying,
"fEwcDivision" character varying(8) NOT NULL DEFAULT ''::character varying,
"fEwcDivNo" integer NOT NULL DEFAULT 0,
"fEwcDivCheck" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcDekID1" character varying(3) NOT NULL DEFAULT ''::character varying,
"fEwcDekID2" character varying(3) NOT NULL DEFAULT ''::character varying,
"fEwcDestination1" character varying(28) NOT NULL DEFAULT ''::character varying,
"fEwcDestination2" character varying(28) NOT NULL DEFAULT ''::character varying,
"fEwcClrMasID" character varying(4) NOT NULL DEFAULT '0'::character varying,
"fEwcCutPrint" smallint NOT NULL DEFAULT 0,
"fEwcMark" double precision NOT NULL DEFAULT 0,
"fEwcLength" double precision NOT NULL DEFAULT 0,
"fEwcForcePrint" character(1) NOT NULL DEFAULT '0'::character varying,
"fEwcSetFlag1" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB1" integer NOT NULL DEFAULT 0,
"fEwcBackRGB1" integer NOT NULL DEFAULT 0,
"fEwcSetFlag2" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB2" integer NOT NULL DEFAULT 0,
"fEwcBackRGB2" integer NOT NULL DEFAULT 0,
"fEwcSetFlag3" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB3" integer NOT NULL DEFAULT 0,
"fEwcBackRGB3" integer NOT NULL DEFAULT 0,
"fEwcSetFlag4" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB4" integer NOT NULL DEFAULT 0,
"fEwcBackRGB4" integer NOT NULL DEFAULT 0,
"fEwcSetFlag5" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB5" integer NOT NULL DEFAULT 0,
"fEwcBackRGB5" integer NOT NULL DEFAULT 0,
"fEwcSetFlag6" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB6" integer NOT NULL DEFAULT 0,
"fEwcBackRGB6" integer NOT NULL DEFAULT 0,
"fEwcSetFlag7" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB7" integer NOT NULL DEFAULT 0,
"fEwcBackRGB7" integer NOT NULL DEFAULT 0,
"fEwcSetFlag8" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB8" integer NOT NULL DEFAULT 0,
"fEwcBackRGB8" integer NOT NULL DEFAULT 0,
"fEwcSetFlag9" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB9" integer NOT NULL DEFAULT 0,
"fEwcBackRGB9" integer NOT NULL DEFAULT 0,
"fEwcSetFlag10" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB10" integer NOT NULL DEFAULT 0,
"fEwcBackRGB10" integer NOT NULL DEFAULT 0,
"fEwcSetFlag11" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB11" integer NOT NULL DEFAULT 0,
"fEwcBackRGB11" integer NOT NULL DEFAULT 0,
"fEwcSetFlag12" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB12" integer NOT NULL DEFAULT 0,
"fEwcBackRGB12" integer NOT NULL DEFAULT 0,
"fEwcSetFlag13" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB13" integer NOT NULL DEFAULT 0,
"fEwcBackRGB13" integer NOT NULL DEFAULT 0,
"fEwcSetFlag14" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB14" integer NOT NULL DEFAULT 0,
"fEwcBackRGB14" integer NOT NULL DEFAULT 0,
"fEwcPrint" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcPrintOver" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcCutPrintOver" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcDemPrintOver" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcUpDivision" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcUpDivPosition" smallint NOT NULL DEFAULT 0,
"fEwcDownDivision" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcDownDivPosition" smallint NOT NULL DEFAULT 0,
wwwwb 2008-03-11
  • 打赏
  • 举报
回复
SELECT TRIM(fEwcDivision) FROM "TempData_TableC002700" WHERE len(TRIM(fEwcDivision))>0 GROUP BY TRIM(fEwcDivision)

trim中应该是字段名吧,fEwcDivision、fEwcDivision,如加引号,则是字符串
liuyann 2008-03-11
  • 打赏
  • 举报
回复

select distinct TRIM(fEwcDivision) FROM TempData_TableC002700 WHERE TRIM(fEwcDivision)<>''

== 思想重于技巧 ==

56,675

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧