This is No. 6 from Debussy’s “Children’s Corner” Suite. This is the first time I have used a score from the International Music Score Library Project.

I have been delighted by this piece since I first heard it as a young lad, but I have only made opportunity to play it now, many years later. I hope you enjoy its playful nature.

Read more about my piano recording series here.

 

 Debussy - Golliwog's Cakewalk [3:05m]: Play Now | Play in Popup | Download

(crossposted from simplyexplained.com)

Under the Code of Canon Law, #917 through 921. notwithstanding the exceptions noted, may one receive Holy Communion outside of Mass? For example, one receives Holy Communion before Mass, because he or she can not stay for a Mass due to a prior personal commitment, say a doctor”s appointment. Or, one comes to Mass late, without good reason, to receive Holy Communion.

I am not a canon lawyer. You should consult one for definitive legal advice.

Canon #918 states

It is most strongly recommended that the faithful receive holy communion in the course of a eucharistic celebration. If, however, for good reason they ask for it apart from the Mass, it is to be administered to them, observing the liturgical rites.

As far as I know, “good reasons” only include severe restrictions such as illness which renders the person non-ambulatory. I would think that other personal commitments of a “normal” or commonplace nature are not sufficient justification for transgressing Church law.

Furthermore, from a more spiritual standpoint, one must consider whether one’s priorities are rightly ordered when one willingly chooses something over the very person of Christ himself, his very Body and Blood, Soul and Divinity.

See also this good reference article by Fr. William Saunders from the Arlington Catholic Herald.

If you want to concatenate multiple row results into one string, use this:

SELECT array_to_string(
  array(
    SELECT text_column
    FROM some_table
    WHERE foo = 'bar'
  ),
  ', '
);

To concatenate multiple columns for each row, use the normal text concatenation operator, ||.

SELECT array_to_string(
  array(
    SELECT text_column || '; ' || another_column
    FROM some_table
    WHERE id = 123
  ),
  ', '
);

Example

db=> SELECT * FROM users;

 firstname | lastname
-----------+----------
 John      | Doe
 Jane      | Doe
 Joe       | Bloe
(3 rows)

db=> SELECT array_to_string(
  array(
    SELECT lastname || ', ' || firstname
    FROM users
  ),
  '; '
);

         array_to_string
---------------------------------
 Doe, John; Doe, Jane; Bloe, Joe

The proof of love is to suffer for the one you love.

Padre Pio