Calender
Sun Mon Tue Wed Thu Fri Sat
      1
2345678
9101112131415
16171819202122
23242526272829
30      
<< September 2018 >>
広告
SEARCH

SELECTED ENTRIES
RECENT COMMENTS
RECENT TRACKBACK
CATEGORIES
ARCHIVES
LINKS
PROFILE
OTHERS
SKYPE
PC: skype.jojo.jp
chat
iPad: iphone.jojo.jp
chat call
THANKS



本日:
昨日:
多言語
広告
 ▼▲ 作業日報 ▼△
    What's under the hood?
<< フォルダ内のmdbのテーブル構造をXML化するスクリプト | main | 花畑牧場・生キャラメル(北海道土産) >>
【PostgreSQL】specified more than once
名無しフィールドは1つまで、
検証コード:
drop table if exists pg_temp.ttest cascade;
create temp table ttest (
  id int,
  dt int
);

drop view if exists pg_temp.vtest cascade;
create temp view vtest as select id,'test'::text from ttest;
/*
drop view if exists pg_temp.vtest;
create temp view vtest as select id,'test'::text,'test'::text from ttest;
--ERROR: column "text" specified more than once
*/
/*
drop view if exists pg_temp.vtest cascade;
create temp view vtest as select sum(id),sum(dt) from ttest;
--ERROR: column "sum" specified more than once
*/

緑部分はNG
| 開発関連 | 10:19 | comments(0) | trackbacks(0) |









http://blog.jojo.jp/trackback/1263060