xjamundx

// articles per page
var limit = 10;

// pagination middleware function sets some
// local view variables that any view can use
function pagination(req, res, next) {
    var page = parseInt(req.params.page) || 1,
        num = page * limit;
    db.articles.count(function(err, total) {
        res.local("total", total);

matthewlehner

#!/bin/bash
#
# PostgreSQL Backup Script Ver 1.0
# http://autopgsqlbackup.frozenpc.net
# Copyright (c) 2005 Aaron Axelsen <[email protected]>
#
# This script is based of the AutoMySQLBackup Script Ver 2.2
# It can be found at http://sourceforge.net/projects/automysqlbackup/
#
# The PostgreSQL changes are based on a patch agaisnt AutoMySQLBackup 1.9

rponte

package rponte.report;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.JRException;

tbarbugli

SELECT  'SELECT SETVAL(' ||quote_literal(S.relname)|| ', MAX(' ||quote_ident(C.attname)|| ') ) FROM ' ||quote_ident(T.relname)|| ';'
FROM pg_class AS S, pg_depend AS D, pg_class AS T, pg_attribute AS C
WHERE S.relkind = 'S'
    AND S.oid = D.objid
    AND D.refobjid = T.oid
    AND D.refobjid = C.attrelid
    AND D.refobjsubid = C.attnum
ORDER BY S.relname;

marko-asplund

--
-- ** setting up example tables and data **
-- 
-- 

CREATE TABLE task (
  id BIGSERIAL ,
  name TEXT,
  parent_id BIGINT REFERENCES task(id),
  PRIMARY KEY (id)

willurd

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

everdaniel

-- Function: im_detalle_1_actualiza_ingreso()

-- DROP FUNCTION im_detalle_1_actualiza_ingreso();

CREATE OR REPLACE FUNCTION im_detalle_1_actualiza_ingreso()
  RETURNS trigger AS
$BODY$
DECLARE
  -- Declaramos las variables con el mismo tipo del definido en la tabla
  iva_5 ingreso_mercaderia.im_impuesto_5%TYPE;

jpetitcolas

-- Decoding
SELECT CONVERT_FROM(DECODE(field, 'BASE64'), 'UTF-8') FROM table;

-- Encoding
SELECT ENCODE(CONVERT_TO(field, 'UTF-8'), 'base64') FROM table;

hschnegg

select (mytext ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$');

myitcv

\dx 

-- See what extensions are loaded

create extension timetravel;

-- load the timetravel extension

-- after installing the latest version