ejrh

# From http://www.mieliestronk.com/wordlist.html
aardvark
aardwolf
aaron
aback
abacus
abaft
abalone
abandon
abandoned

ejrh

DIMENSIONS = 2
SCALE = 3
OUTER_SCALE = SCALE + 2
STEPS = tuple(OUTER_SCALE**x for x in reversed(range(DIMENSIONS)))

def generate_all_cells():
    def do_slice(offset, depth):
        if depth == DIMENSIONS - 1:
            for i in range(1, SCALE + 1):
                yield offset + i

ejrh

with v as (select version() as ver),
constants(relkind, block_size, header_size, max_align, fill_factor, nonleaf_fill_factor, page_overhead, row_overhead) as (
    values (
        'r',
        current_setting('block_size'),
        CASE WHEN SUBSTRING((select ver from v),12,3) IN ('8.0','8.1','8.2') then 28 else 24 end,
        CASE WHEN (select ver from v) ~ 'mingw32|64' THEN 8 ELSE 4 end,
        1.0,
        null,
        32,

ejrh

import itertools
import math
import random
import time


DEPENDENCIES = {
    'wires': {'copper'},
    'green circuits': {'iron', 'wires'},
    'red circuits': {'plastic', 'wires', 'green circuits'},

ejrh

WITH RECURSIVE t AS
(
    SELECT id, '{}'::int[] AS parents, 0 AS level
    FROM z_msg WHERE in_reply_to IS NULL
UNION ALL
    SELECT c.id, parents || c.in_reply_to, level+1
    FROM t JOIN z_msg AS s c ON t.id = c.in_reply_to
),
t2 AS

ejrh

04/09/2013
		
2 cups of flour, sifted with:
1/2 teaspoon salt
1 heaped tablespoon cocoa
1 level teaspoon baking powder
1 level tspn soda

Put in blender 1 cup dates (check for stones),

ejrh

#include <boost/shared_ptr.hpp>
#include <boost/make_shared.hpp>

class Message {
};

class Receiver {
public:
    virtual ~Receiver() { }
    virtual void receive(Message *msg) = 0;

ejrh

CREATE OR REPLACE FUNCTION public.forecast_base_1_part_trig_func()
  RETURNS trigger AS
$BODY$
            DECLARE
            v_count                 int;
            v_partition_name        text;
            v_partition_timestamp   timestamptz;
        BEGIN 
        IF TG_OP = 'INSERT' THEN 
            v_partition_timestamp := date_trunc('day', NEW.nwp_analysis_at_date);

ejrh

filesys=# \d file
                                    Table "public.file"
  Column  |            Type             |                     Modifiers
----------+-----------------------------+---------------------------------------------------
 id       | integer                     | not null default nextval('file_id_seq'::regclass)
 name     | character varying           | not null
 size     | bigint                      | not null
 modified | timestamp without time zone |
 md5      | character(32)               |
Indexes:

ejrh

CREATE TABLE forecast_base_0
(
  nwp_analysis_at_date timestamp without time zone NOT NULL,
  nwp_analysis_at_time_period smallint NOT NULL,
  nwp_analysis_prognosis integer NOT NULL,
  issued_prognosis integer NOT NULL,
  valid_from_date timestamp without time zone NOT NULL,
  valid_from_time_period smallint NOT NULL,
  location_id bigint NOT NULL,