#unnest

All of the things you mentioned are possible - the colon can be controlled by using

usernameColon:true

as an option, and for the icon symbol, CSS is a thing, so you can simply do a

a.tumblr_blog::before

unnest #1 was the first episode of a new format co-curated by Barbara Mulas and Cristina Aguirre and developed after the pilot Conversation #5 “an attempt to unnest” (held in May 2017 in Bristol UK). It was part of Victoria Square Project’ Art Residency program, and it took place in Athens, between a public and a private venue in Elpidos Street, on Sunday December 10th from 2 to 10pm.

Since NEST is a nomadic reality, geographically spread like a rhizome that often changes context, the purpose of the series unnest came from the need to reshape the meaning of what is NEST from place to place & time to time, to further explore the dichotomy of comfort/discomfort applied to the different places it works in.

For this residency, NEST underpinned both Athens’ context (a series of major issues later defined “macro discomfort”) and the presence of the individuals (and his/her comfort-zone, contrarily defined as “micro discomfort”). unnest #1 focus in Athens was around the dichotomy of macro and micro: the study of the macro, yet the recognition of the importance of the micro within it.

The residency was conceived as an experiment, a one-month dialogical conversation developed with and through the contribution of different disciplines, genres and artists’ personal philosophical approaches. The final outcome was an eight-hours performative & interactive event that counted two venues, twelve contributors and more than 70 visitors.

More materials to come In the meanwhile, check SKOLLA’ + LANE special set streamed live from Bristol, available from this link

PERFORMERS & CONTRIBUTORS

Anne Marie Slater Daniele Guerrini Eleonora Gambula Emiliano Mendoza EQUOHM Frankie Mills Gabriella Ferrante Ma Dam Marcelina Obarska Paola Moretti SKOLLA’ + LANE YŪ

THANKS TO

Victoria Square Project Team Eleonora Meoni Jan Uprichard

Hi! Paragraphs display in blocks by default, so you’ll have to add a display:inline; to your captions’ paragraphs.

.tumblr_parent p {display:inline;}

I didn’t want to break the functionality of paragraphing though so I only had the first paragraph display as inline:

.tumblr_parent p:first-of-type {display:inline;}

or you could have:

.tumblr_parent > a.tumblr_blog + p:first-of-type {display:inline;}

to only have those paragraphs directly following the username link display as inline.

Três funções simples para manipular arrays no PostgreSQL

Neste episódio apresento três funções para manipular arrays no PostgreSQL. São funções simples, mas muito uteis para utilizar em funções e consultas um tanto que exóticas.

A versão do PostgreSQL utilizada foi a 9.1.

Comandos:

SELECT array_to_string(array[1,2,3,4,5,6],','); SELECT array_to_string(array[1,2,3,4,5,6],'|'); SELECT array_to_string(array[1,2,3,4,5,6],'#'); SELECT array_to_string(array[1,2,3,4,5,6],'aaa'); SELECT array_to_string(array[1,2,3,4,5,6],''); SELECT array_to_string(array[1,2,3,4,null,6],''); SELECT array_to_string(array[1,2,3,4,null,6],'|'); SELECT array_to_string(array[1,2,3,4,null,6],'|','*'); SELECT array_to_string(array[1,2,3,4,null,6],'|',' '); SELECT array_to_string(array[1,2,3,4,null,6],'|','NULO'); SELECT array_to_string(array[1,2,3,4,null,6],'|','NULL'); SELECT string_to_array('name,phone,city', ','); SELECT string_to_array('name,phone,city', ',', 'city'); SELECT * from unnest(array[1,2,3,4,5,6]); SELECT * from unnest(string_to_array('name,phone,city',','));

Mais informações:

http://www.postgresql.org/docs/9.1/static/arrays.html