postgres

code related to postgreSQL.

server side C

• mule -> utf8
• human(int8) display a human-readable string representing a number like: 8.1GB http://maruska.dyndns.org/comp/activity/c/pg/human/

Gentoo

bookmarks:

NEsted, transitive closure

http://threebit.net/tutorials/nestedset/tutorial1.html http://www.dbazine.com/oracle/or-articles/tropashko4 http://www.sai.msu.su/~megera/postgres/gist/ltree/ http://www.mrnaz.com/static/articles/trees_in_sql_tutorial/

EXPLAIN VERBOSE

http://pgsqld.active-venture.com/planner-optimizer.html

http://www.varlena.com/varlena/GeneralBits/116.php

http://www.postgresql.org/docs/7.4/static/protocol-message-formats.html RowDescription (B)

see postgres-fsource

Creating a new DB

why does it work w/ strace, but not w/o it? ; strace -f -e open * unset LANG; LC_ALL="C" LC_COLLATE="C" LC_MESSAGES='C' initdb

[14 lug 06] LC_MESSAGE="it" initdb works!

Create the DB:

users.sql

psql -h /tmp/ template1 -f /linux/11/x/activity/sql/init/users.sql 
pg_dump  -C  maruska | psql -h /tmp/ template1 

??? psql:/linux/10/postgres/structure.dec2:9834: ERROR: permission denied for language c UPDATE pg_shadow set usesuper = 't' where usename 'mmc' or usename'beta';

-- select * from pg_authid;

functions:

emerge agenzia with the postgresql USE flag, -> emerges many C functions, which I need.

ret.so ?? char_in_set.so int_counter.so

human ??

sql/functions/aggregate/concat.sql

transfer