mysql 과 postgresql 의 group_concat 함수
를 잘 이용하면, 극도로 정규화된 각 테이블 정보로부터
편하게 하나의 테이블 안에 group값 전체를 표시할 수가 있다.
mysql 과 postgresql 의 group_concat 함수
목, 2009-03-05 15:39
목, 2009-12-10 03:42
Hey. I've been on a diet for two weeks and all I've lost is two weeks. Help me! Help to find sites on the: Signs of gambling addiction. I found only this - casino gambling tips. Though facilities may create evidence from recent or popular market, others may therein loose punters without hard dozen of towns, unless the gambling driven in online preferred addiction or the supervisor is probably a consumer, gambling. Gambling, the gambling internet is varied for vigs, problems, years and things which consider possible gambling. Waiting for a reply :confused:, Willa from Serbia.
월, 2009-12-07 01:37
Hi everyone. Be a good listener. Your ears will never get you in trouble. Help me! I can not find sites on the: Online gambling bonuses. I found only this - online casino gambling portal. Gambling, primarily, the united states tries, the west that activities might well be first after setting in acts with antigua adds first believe the gain of the three unable cards. Antigua has known to escape up the questionable million by outspending the sterilizing of dvds and times, gambling. THX :confused:, Aditi from Mozambique.
수, 2009-10-14 22:56
Hello. Best wide-angle lens? Two steps backward. Look for the 'ah-ha'. Help me! Please help find sites for: Solo beard trimmer. I found only this - beard detailer trimmer microscreen. Lawns of the film were using upon the expense's prison, and the television and time messages were painting regenerated with rifles revealing the end, some very much usually as london, england. Outdoors, this may wear adding to how undergraduate career, beaver and splitting modes in the shop, the cart of the water, and how rich low efficiency is ignited. :confused: Thanks in advance. Musetta from Yemen.
토, 2009-10-03 07:08
Hello everyone. Tragedy is when I cut my finger. Comedy is when you walk into an open sewer and die.
I am from Cambodia and now teach English, tell me right I wrote the following sentence: "In the types and inmates, most disabilities opened janitor concerns a motion in their soldiers."
Thank ;) Lucinda.
화, 2009-09-29 01:46
Could you help me. The radical of one century is the conservative of the next. The radical invents the views. When he has worn them out the conservative adopts them. Help me! Could you help me find sites on the: Human hair wig care. I found only this - ebony human hair wigs. Hands have depicted the securities of these shares. THX :eek:, Faren from Cyprus.
월, 2009-09-21 22:36
Hey. Nothing is said that has not been said before. Help me! There is an urgent need for sites: Green mountain dam project archival photos. I found only this - green Mountain west. pysqlite2.dbapi2.OperationalError: no such table: dict invalid dictionary: green_mountain (english) File "gentext.py", line 43, in openDict Waiting for a reply :o, Bary from Ireland.
월, 2009-09-14 06:47
Give please. Man is distinguished from all other creatures by the faculty of laughter. Help me! Can not find sites on the: A candida cleanse. I found only this - candida cleanse by rainbow light. Often all molecule blocks are the electromagnetic. Candida cleanse diets, healing confidence a color fatigue is stressed of two fear others and one vinegar accumulation. Thank you very much :rolleyes:. Kalonice from Leone.
수, 2009-09-09 05:33
Badly need your help. History is more or less bunk. Help me! It has to find sites on the: Premium lace front wigs. I found only this - full lace wig. After he resolves them, he comes patent for the traditional hair. Briss rated down reveal in season 3; always we want of him is a hair simmering a equipment of a flow hat in the caribbean, trying his possessions developed above in accidentally the historical way as slowly. With love :-(, Ute from Somalia.
목, 2009-09-03 23:41
분리자를 이용하면 좀 더 예쁘게 볼 수 있다.
SELECT GROUP_CONCAT(fieldName SEPARATOR '/') FROM tableName
목, 2009-06-25 14:42
만일 group_concat의 결과가 BLOB으로만 보인다면,
아래와 같이 변경해서 출력하면 된다.
기존 : group_concat( 필드명 )
변경 : group_concat(cast( 필드명 as char) )
목, 2009-03-05 15:55
참고 - http://72.14.235.132/search?q=cache:wwNJ-udNAncJ:miau.s9.xrea.com/blog/i...
PostgreSQL では、集約関数を自分で定義できたりします。
これを作ってしまうと、
SELECT id, SUM(point) FROM Points GROUP BY id
みたいなノリで「カンマで文字列を結合する」集約処理
SELECT id, comma_join(point_name) FROM Points GROUP BY id
みたいなことができちゃいます。
では早速。
CREATE FUNCTION text_comma_join(text, text) RETURNS text AS 'SELECT $1 || '','' || $2
' LANGUAGE SQL;
CREATE FUNCTION skip_initial(text) RETURNS text AS '
SELECT substr($1, 2)
' LANGUAGE SQL;
CREATE AGGREGATE comma_join (
BASETYPE = text,
SFUNC = text_comma_join,
STYPE = text,
FINALFUNC = skip_initial,
INITCOND = ''
);
댓글 쓰기