2009-11-01から1ヶ月間の記事一覧

$GLOBALSの挙動サンプルコード

class alpha{ function __construct(){ $GLOBALS['xxx'] = $GLOBALS['xxx'] + 1; } } class beta{ function __construct(){ $GLOBALS['xxx'] = $GLOBALS['xxx'] + 2; } } class gamma{ function __construct(){ $GLOBALS['xxx'] = $GLOBALS['xxx'] + 3; } }$…

テーブル名と列名と型とサイズ一覧取得sql あ〜さ〜ver0.02

上記のさらに改悪VerSELECT sut.relid AS TABLE_ID ,sut.relname AS TABLE_NAME ,att.attnum AS COL_NUM ,att.attname AS COL_NAME ,typ.typname AS COL_TYPE ,CASE typ.typname WHEN 'varchar' THEN att.atttypmod-4 WHEN 'bpchar' THEN att.atttypmod-4 WH…

テーブル名と列名と型とサイズ一覧取得sql あ〜さ〜ver0.01

http://d.hatena.ne.jp/absj31/20080310/1205091108 のSQLを改悪しました。 SELECT sut.relname, pg_attribute.attnum AS NUM, pg_attribute.attname AS COL_NAME, typ.typname AS COL_TYPE, CASE typ.typname WHEN 'varchar' THEN pg_attribute.atttypmod-4…