pgsql-sql - August 2011

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 8 9 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 28 30 31

Aug. 1, 2011

Thread Author Time
why these results? Wes James 22:50
Re: why these results? Adrian Klaver 23:00
Re: why these results? Reinoud van Leeuwen 23:01
Re: why these results? Steve Crawford 23:01

Aug. 2, 2011

Thread Author Time
Re: why these results? Wes James 14:13
Re: [SQL] Help with regexp-query Charlie 17:06
Aggregating results across multiple partitions Mike O'Connel 20:20

Aug. 3, 2011

Thread Author Time
Re: Help with regexp-query Tim Landscheidt 04:05
Generic design: char vs varchar primary keys Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 15:10
Re: Generic design: char vs varchar primary keys Josh Kupershmidt 22:24

Aug. 4, 2011

Thread Author Time
Re: Generic design: char vs varchar primary keys Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 01:58
Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar 07:54
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Amitabh Kant 11:03
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar 11:42
Mysterious column "name" Nikolay 14:50
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Charlie 21:54
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Samuel Gendler 22:24

Aug. 5, 2011

Thread Author Time
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar 09:07
Re: Generic design: char vs varchar primary keys Jasen Betts 12:40
Re: Generic design: char vs varchar primary keys Jasen Betts 12:43

Aug. 8, 2011

Thread Author Time
Problem with nested left-joins and coalesce ai 06:53
Re: Problem with nested left-joins and coalesce Carla 15:02
Re: Problem with nested left-joins and coalesce ai 15:34
Re: Problem with nested left-joins and coalesce Carla 19:14

Aug. 9, 2011

Thread Author Time
Re: Mysterious column "name" Oliveiros d'Azevedo Cristina 15:34
Re: Mysterious column "name" Steve Crawford 16:00
Re: Mysterious column "name" Tom Lane 16:04

Aug. 11, 2011

Thread Author Time
Stuck Up In My Own Category Tree Don Parris 15:39
Re: Stuck Up In My Own Category Tree Samuel Gendler 16:24
Re: Stuck Up In My Own Category Tree jasmin.dizdarevic 16:29
Re: Stuck Up In My Own Category Tree Edward W. Rouse 16:48
Re: Stuck Up In My Own Category Tree Don Parris 21:21

Aug. 12, 2011

Thread Author Time
Using variables in select tlund79 11:05
Re: Using variables in select Oliveiros d'Azevedo Cristina 16:03

Aug. 13, 2011

Thread Author Time
pgadmin debugger David Harel 19:39
Re: pgadmin debugger Adrian Klaver 19:56

Aug. 14, 2011

Thread Author Time
bigint and unix time Janiv Ratson 11:13
Re: pgadmin debugger David Harel 17:15
Re: bigint and unix time Adrian Klaver 17:57
Re: pgadmin debugger Adrian Klaver 18:07
Re: pgadmin debugger David Harel 18:33

Aug. 15, 2011

Thread Author Time
Re: bigint and unix time Janiv Ratson 06:23
Calculate the ratio Andreas Forø Tollefsen 12:21
Re: Calculate the ratio msi77 13:00
Re: Calculate the ratio David Johnston 13:08
Re: Calculate the ratio David Johnston 13:10
Re: pgadmin debugger Adrian Klaver 13:49
Re: Calculate the ratio Andreas Forø Tollefsen 13:49
Re: bigint and unix time Adrian Klaver 14:14
Re: pgadmin debugger David Harel 18:53

Aug. 16, 2011

Thread Author Time
F_TABLE_NUMBER_RANGE equivalent in Postgresql Yuan HOng 04:53
Re: F_TABLE_NUMBER_RANGE equivalent in Postgresql msi77 05:19
Re: F_TABLE_NUMBER_RANGE equivalent in Postgresql Pavel Stehule 05:21
Re: bigint and unix time Janiv Ratson 09:12
Re: bigint and unix time Janiv Ratson 09:15
Re: bigint and unix time Janiv Ratson 09:19
which is better: using OR clauses or UNION? Adam Witney 11:14
which is better: using OR clauses or UNION? adam_pgsql 11:39
Re: which is better: using OR clauses or UNION? Viktor Bojović 11:56
Re: bigint and unix time Adrian Klaver 13:43
Re: which is better: using OR clauses or UNION? David Johnston 14:06
Re: which is better: using OR clauses or UNION? Tom Lane 14:09
Re: which is better: using OR clauses or UNION? Jasen Betts 14:27
Re: which is better: using OR clauses or UNION? adam_pgsql 14:52
Re: which is better: using OR clauses or UNION? adam_pgsql 15:55
Re: which is better: using OR clauses or UNION? Igor Neyman 17:43
parsing audit table M. D. 21:02
Re: parsing audit table M. D. 21:48
Re: [SQL] parsing audit table Jaime Casanova 23:35

Aug. 17, 2011

Thread Author Time
Re: which is better: using OR clauses or UNION? Igor Neyman 20:26

Aug. 18, 2011

Thread Author Time
Cursor names in a self-nested function Kidd, David M 14:53
Re: Cursor names in a self-nested function Pavel Stehule 15:36
Re: Cursor names in a self-nested function Tom Lane 16:15

Aug. 19, 2011

Thread Author Time
(pgsql8.4) DATA Corruption Mikola Rose 19:08
Re: (pgsql8.4) DATA Corruption Scott Marlowe 20:02
Re: (pgsql8.4) DATA Corruption Mik Rose 20:27

Aug. 21, 2011

Thread Author Time
exclusion constraint for ranges of IP Herouth Maoz 15:08
Re: exclusion constraint for ranges of IP Harald Fuchs 22:19

Aug. 22, 2011

Thread Author Time
Re: exclusion constraint for ranges of IP Herouth Maoz 08:31
Re: exclusion constraint for ranges of IP Simone Sanfratello 09:27
Re: exclusion constraint for ranges of IP Jasen Betts 11:37
Re: exclusion constraint for ranges of IP Misa Simic 13:07
sorting months according to fiscal year Enzen user 13:27
Re: sorting months according to fiscal year Pavel Stehule 13:39
Confused about writing this stored procedure/method. JavaNoobie 14:38
Re: exclusion constraint for ranges of IP Harald Fuchs 15:20
Re: Confused about writing this stored procedure/method. Pavel Stehule 16:05
Re: sorting months according to fiscal year Gavin Flower 23:58

Aug. 23, 2011

Thread Author Time
Re: exclusion constraint for ranges of IP Herouth Maoz 08:27
WITH RECURSIVE question 📎 Julien Cigar 10:03
Re: Confused about writing this stored procedure/method. Jasen Betts 10:14
Re: exclusion constraint for ranges of IP Samuel Gendler 10:15
Re: exclusion constraint for ranges of IP Jasen Betts 10:31
Re: exclusion constraint for ranges of IP Herouth Maoz 11:39
Re: WITH RECURSIVE question 📎 Julien Cigar 14:39
need magic to shuffle some numbers Andreas 19:49

Aug. 24, 2011

Thread Author Time
Re: need magic to shuffle some numbers Samuel Gendler 00:17
Re: Confused about writing this stored procedure/method. Tim Landscheidt 14:07
Re: need magic to shuffle some numbers Tim Landscheidt 14:15

Aug. 25, 2011

Thread Author Time
new table with a select ppdcc 09:35
new table with a select ppdcc 09:44
Re: new table with a select 📎 Julien Cigar 09:48
Re: new table with a select Florian Weimer 10:44
Add one column to another gvim 14:21
Re: Add one column to another Tony Capobianco 14:30
Re: Add one column to another Oliveiros d'Azevedo Cristina 14:52
Re: Add one column to another David Johnston 14:53
Re: Add one column to another Tim Landscheidt 17:50
Re: Add one column to another Scott Marlowe 17:54
Re: Add one column to another vipul shah 19:46
st_offsetcurve ppdcc 20:17
Need a little help with geometric query lxnf98mm 22:56
Re: st_offsetcurve Brent Dombrowski 23:35

Aug. 26, 2011

Thread Author Time
Re: Need a little help with geometric query Samuel Gendler 00:08
Re: (pgsql8.4) DATA Corruption Craig Ringer 03:51
Re: new table with a select MIkhail Puzanov 07:06

Aug. 28, 2011

Thread Author Time
Re: [SQL] parsing audit table Jan Eskilsson 10:00

Aug. 30, 2011

Thread Author Time
where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 14:51
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? 📎 Julien Cigar 15:01
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Tom Lane 15:24
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 15:48
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Tom Lane 15:53
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 15:57

Aug. 31, 2011

Thread Author Time
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emre Hasegeli 07:16
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Jasen Betts 10:17
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 12:54
ERROR: cannot subscript type text because it is not an array lxnf98mm 13:26
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Pavel Stehule 16:16
function based index problem Viktor Bojović 21:27
Re: function based index problem Kevin Grittner 21:53
Re: [SQL] function based index problem David Johnston 22:09
Re: function based index problem Viktor Bojović 22:17
Re: function based index problem Viktor Bojović 22:21

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 8 9 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 28 30 31