#alter type

[mimiscoiningcafe]

Exogod - An exogod is an entity considered, experienced, or self-identified as a god external to a system.

Intragod - An entity considered, experienced, or self-identified as a god internal to a system.

Praesigod - An entity considered, experienced, or self-identified as a god who would strongly prefer not to label themselves as either an internal or external god.

Quoigod - An entity within a system considered, experienced, or self-identified as a god who does not know, care, or consider important whether they are an internal or external god, or whose worldview lacks a distinction between internal and external gods.

Not coined by us&.

Exogod and intragod were inspired by @/plural-the-way-you-dont-like (not pinging right here because that's lower down)'s intragod flag, praesigod was inspired by extranth (deactivated)'s praesigenic flag, and quoigod was inspired by Selenelion Aberration's quoigenic flag.

We& consent to our flags being used for personal use and for wikis, as long as we& are credited!

===

Hi there! I plan on making a post talking about my& ✨ feelings ✨ in regards to why we& stopped posting as much. Nothing too bad, just felt like it was polite to tell people why.

But until then: enjoy the flags!

Also here's the @ list (tell me if you want to join, i'm just mostly tagging ones that are archival blogs + some of the creators who are on tumblr. same with being removed!!): @radiomogai, @system-term-archive (this is my own blog, it's just to remind me to actually reblog onto it), @plural-the-way-you-dont-like (intragod's colors were from their& flag and extragod's is the reverse of it :3), @mogaiqueued

[thehoneyveil]

— ZOMBiE ALTER FLAG !!

𓂃۶ৎ A flag for alters who are a zombie, act like a zombie, or feel like a zombie in some way, shape or form!

𓂃۶ৎ This flag was created by Mod Worm !

[pgcasts-blog]

Alterando colunas de tipos conflitantes no PostgreSQL

Neste episódio demonstro como alterar colunas de tabelas quando o tipo de destino é conflitante. Nem sempre é possível fazer isso diretamente, por isso é necessário utilizar alguns artifícios.

Mais informações:

http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html

Comandos:

BEGIN; ALTER TABLE contatos ALTER cpf TYPE numeric USING CAST(cpf AS numeric); ALTER TABLE contatos ALTER idade TYPE date USING NULL; ALTER TABLE contatos RENAME total_dias_cadstrado TO data_cadastro; ALTER TABLE contatos ALTER data_cadastro DROP DEFAULT; ALTER TABLE contatos ALTER data_cadastro TYPE date USING current_date - CAST(data_cadastro||' days' as interval); ALTER TABLE contatos ALTER data_cadastro SET DEFAULT now(); COMMIT;