Archive for the 'pl/pgsql' Category

[Russian] PostgreSQL forum on SQL.RU: Boolean events and a query to define similarity // как лучше сделать запрос для определения похожести событий? / PostgreSQL : Форум на SQL.RU

Tuesday, April 22nd, 2008

Say we have a table with a lot of boolean columns. One row in that table defines an “event” entity, so basically event 1 can look like 00001 and event 2 can look like 01001. Post discusses a ways to define similarities between events (XOR)

<(-_-)> on PostgreSQL

Thursday, April 10th, 2008

Blog of Kristo Kaiv – Skype architect / DBA

снова про деревья / PostgreSQL : Форум на SQL.RU

Saturday, December 1st, 2007

simple tree for cascade menues in postgers

blog: Stacked recordset (multirecordset) PostgreSQL PL/pgsql

Saturday, December 1st, 2007

multi-records set and cross-table queries

» Blog Archive » find overlapping time ranges

Saturday, December 1st, 2007

how to use “search by timerange” postgres and use index

Horses are terrible people.: First impressions of plProxy

Saturday, December 1st, 2007

notes on Pl/Proxy (interdatabase connectivity for stored prosedures )

Re: hexadecimal to decimal [in postgresql]

Monday, November 19th, 2007

how to convert hex to decimal in Postgres

Pl/Pgsql – Greg’s Postgres stuff

Wednesday, November 14th, 2007

some interesting notes on PL/PGSQL programing

PostgreSQL: PostgreSQL 7.3 Set Returning Functions

Friday, June 15th, 2007

returning multiple rows from a function in postgresql