pgsql-sql since 2011-08-01 00:00

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

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

Sept. 1, 2011

Thread Author Time
Want some basic compare of data type on PostgreSQL and MySQL bhavesh1385 05:15
Re: Want some basic compare of data type on PostgreSQL and MySQL Scott Marlowe 09:16
Re: Want some basic compare of data type on PostgreSQL and MySQL Samuel Gendler 09:38
Re: Want some basic compare of data type on PostgreSQL and MySQL Jasen Betts 11:22
Re: Want some basic compare of data type on PostgreSQL and MySQL Leif Biberg Kristensen 13:32
Re: Want some basic compare of data type on PostgreSQL and MySQL Scott Marlowe 13:45
Schema partitioning Charlie 18:13

Sept. 2, 2011

Thread Author Time
Re: Schema partitioning David Johnston 13:20
Re: Schema partitioning Little, Douglas 13:22

Sept. 7, 2011

Thread Author Time
How can I inherit constraints? Andreas 01:04

Sept. 9, 2011

Thread Author Time
My Trigger is not working :( Waqar Azeem 12:27
Re: how can I get the length of columns of a table by system tables/views shuaixf 12:53
Re: My Trigger is not working :( pasman pasmański 13:23
Re: My Trigger is not working :( Waqar Azeem 13:31

Sept. 10, 2011

Thread Author Time
Re: Re: how can I get the length of columns of a table by system tables/views msi77 05:51
Dynamic sql Gabriel Filipiak 06:45
Re: Dynamic sql Jasen Betts 09:18
FW: Hi Mandana Mokhtary 21:22
FW: Hi Mandana Mokhtary 21:22
Re: FW: Hi Adrian Klaver 22:04

Sept. 12, 2011

Thread Author Time
Re: FW: Hi Craig Ringer 01:31
Use select and update together Boris 10:36

Sept. 13, 2011

Thread Author Time
Re: Use select and update together pasman pasmański 05:50
Re: Use select and update together Samuel Gendler 06:45
Partition over a sliding date window Guillaume Roger 11:25
Window function sort order help Dianna Harter 18:04
Re: Window function sort order help nicoletta maia 20:53

Sept. 14, 2011

Thread Author Time
Re: Window function sort order help Nicoletta Maia 08:30
Re: Window function sort order help Thomas Kellerer 09:02
Re: Window function sort order help Dianna Harter 16:54
Re: Window function sort order help Nicoletta Maia 17:24

Sept. 15, 2011

Thread Author Time
Clever way to check overlapping time intervals ? Andreas 23:40

Sept. 16, 2011

Thread Author Time
Re: Clever way to check overlapping time intervals ? Andreas Kretschmer 00:15
Re: Clever way to check overlapping time intervals ? pasman pasmański 09:17
Re: Clever way to check overlapping time intervals ? Frank Bax 11:15
Re: Window function sort order help Tim Landscheidt 23:55

Sept. 17, 2011

Thread Author Time
Passing function parameters to regexp_replace Leif Biberg Kristensen 11:21
Re: Passing function parameters to regexp_replace Leif Biberg Kristensen 11:31
Sorting of data from two tables R. Smith 13:32
Re: Sorting of data from two tables David Johnston 13:56
insert or update within transaction Andreas 14:52
Re: Use select and update together Andreas 14:56
Re: insert or update within transaction Josh Kupershmidt 15:49
Re: Use select and update together Guillaume Lelarge 15:51
Re: Use select and update together Tom Lane 16:16
Re: Passing function parameters to regexp_replace Tim Landscheidt 17:07
Re: Passing function parameters to regexp_replace Leif Biberg Kristensen 17:27
select xpath ... boris 17:48
Re: Passing function parameters to regexp_replace Tim Landscheidt 18:34

Sept. 19, 2011

Thread Author Time
Re: select xpath ... Rob Sargent 14:49
Re: select xpath ... boris 15:49
Re: Window function sort order help Dianna Harter 21:31

Sept. 20, 2011

Thread Author Time
Combining several CTEs with a recursive CTE Thomas Kellerer 09:58
Re: Combining several CTEs with a recursive CTE David Johnston 14:15
Re: Combining several CTEs with a recursive CTE Thomas Kellerer 14:54

Sept. 21, 2011

Thread Author Time
handling duplicate row exception Amar Dhole 05:54
Re: handling duplicate row exception Filip Rembiałkowski 15:07
Re: Trigger Procedure Error: NEW used in query that is not in a rule jablonov 15:32
Re: select xpath ... Brian Sherwood 16:27
ambiguous local variable name in 9.0 proc Samuel Gendler 23:35
Re: ambiguous local variable name in 9.0 proc David Johnston 23:49
Re: ambiguous local variable name in 9.0 proc Samuel Gendler 23:55

Sept. 22, 2011

Thread Author Time
Re: ambiguous local variable name in 9.0 proc Tom Lane 00:00
a spatial table's bounding box Asli Akarsakarya 06:04
Re: handling duplicate row exception Amar Dhole 06:11
help with xpath namespace Brian Sherwood 15:03

Sept. 23, 2011

Thread Author Time
using the aggregate function max() John Fabiani 02:49

Browse Archives

Prev | Next