pgsql-sql since 2009-11-05 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

Nov. 5, 2009

Thread Author Time
Re: Learning about WITH RECURSIVE Tom Lane 00:04
Re: [SQL] Case Preservation disregarding case Erik Aronesty 15:45
Database connection error, try to reset the connection parameters cholid 15:50
Converting T-SQL to PostgreSQL maboyz 20:37
Re: Converting T-SQL to PostgreSQL Pavel Stehule 20:53
Re: Converting T-SQL to PostgreSQL Pavel Stehule 20:55
Foreign key columns Svenne Krap 21:08
Re: Foreign key columns Scott Marlowe 22:21

Nov. 6, 2009

Thread Author Time
Re: Database connection error, try to reset the connection parameters Adrian Klaver 14:42
Re: how to: refer to select list calculations other places in the calculations. the6campbells 19:45

Nov. 10, 2009

Thread Author Time
Re: help-simplify query rafizeldi 02:28

Nov. 11, 2009

Thread Author Time
ORDB and dot-notation query ALLs.org 04:11
Re: ORDB and dot-notation query Richard Broersma 04:15
Re: ORDB and dot-notation query ALLs.org 04:27
Re: ORDB and dot-notation query Tom Lane 04:36

Nov. 13, 2009

Thread Author Time
Caliculating Business Days and adding business days usefull functions for developers bujjibabu 14:27

Nov. 16, 2009

Thread Author Time
Fuzzy match under PostgreSQL 8.0.15 Emi Lu 21:16

Nov. 17, 2009

Thread Author Time
lost password Edward W. Rouse 21:20
Re: lost password Edward W. Rouse 21:43
Re: lost password Tom Lane 23:56

Nov. 18, 2009

Thread Author Time
Re: lost password Edward W. Rouse 15:10
need nelp with aggregate functions 📎 Another Trad 16:55
Re: need nelp with aggregate functions Scott Marlowe 17:07
Re: need nelp with aggregate functions Oliveiros C, 17:16
Re: need nelp with aggregate functions Another Trad 17:37
LIMIT BASED ON PERCENT Another Trad 19:12
Re: LIMIT BASED ON PERCENT Lee Hachadoorian 19:21
Re: LIMIT BASED ON PERCENT Another Trad 19:24
Re: LIMIT BASED ON PERCENT Guillaume Lelarge 19:27
Re: LIMIT BASED ON PERCENT Another Trad 19:28
Re: LIMIT BASED ON PERCENT Pavel Stehule 19:30
Re: LIMIT BASED ON PERCENT Lee Hachadoorian 19:33
Re: LIMIT BASED ON PERCENT Pavel Stehule 19:35
Re: LIMIT BASED ON PERCENT Pavel Stehule 19:39

Nov. 19, 2009

Thread Author Time
Re: LIMIT BASED ON PERCENT Kris Kewley 00:20
Re: LIMIT BASED ON PERCENT Guillaume Lelarge 06:47
Re: need nelp with aggregate functions Oliveiros C, 15:11
Re: need nelp with aggregate functions Another Trad 16:16

Nov. 20, 2009

Thread Author Time
Sqldf - error message Marvelde, Luc te 14:18
Re: Sqldf - error message Pavel Stehule 14:37
Re: Sqldf - error message Tom Lane 14:39
Re: Sqldf - error message Pavel Stehule 14:42
Re: Sqldf - error message Pavel Stehule 14:43
Re: Sqldf - error message Marvelde, Luc te 14:50
Re: Sqldf - error message Rob Sargent 15:36
Re: Sqldf - error message Adrian Klaver 16:23
Re: Sqldf - error message Whit Armstrong 17:11

Nov. 24, 2009

Thread Author Time
CREATE SERVER - what is this? Richard Broersma 15:45

Nov. 26, 2009

Thread Author Time
Profiling tool for postgres under win32 aymen marouani 09:48
Re: Profiling tool for postgres under win32 A. Kretschmer 10:05
Re: CREATE SERVER - what is this? Guillaume Lelarge 10:52
How to start the "auto_explain" module aymen marouani 11:26
Re: Profiling tool for postgres under win32 Craig Ringer 12:05
Re: How to start the "auto_explain" module A. Kretschmer 12:26

Nov. 30, 2009

Thread Author Time
Re: Profiling tool for postgres under win32 aymen marouani 08:42
Re: Profiling tool for postgres under win32 Craig Ringer 09:00
Schema's, roles and privileges Michael Gould 14:50
Re: Schema's, roles and privileges Adrian Klaver 15:08
Re: Schema's, roles and privileges Michael Gould 15:25
Re: Schema's, roles and privileges Harald Fuchs 17:51
Re: How to start the "auto_explain" module Jaime Casanova 22:24

Dec. 1, 2009

Thread Author Time
pg_restore followed by immediate VACUUM ANALYZE Bryce Nesbitt 03:46
Re: pg_restore followed by immediate VACUUM ANALYZE Tom Lane 03:55
Re: pg_restore followed by immediate VACUUM ANALYZE 📎 Bryce Nesbitt 03:59
Re: pg_restore followed by immediate VACUUM ANALYZE Tom Lane 04:04

Dec. 3, 2009

Thread Author Time
create user xxx with md5 string? Gerardo Herzig 18:05
Re: create user xxx with md5 string? Gerardo Herzig 19:02
Re: create user xxx with md5 string? Tom Lane 19:21
Re: create user xxx with md5 string? Dmitriy Igrishin 19:36
Re: create user xxx with md5 string? Dmitriy Igrishin 19:38

Dec. 4, 2009

Thread Author Time
get sequence name from table name Uwe Maiwald 16:53
Getting more than one row in UNIQUE fields Another Trad 17:24
Re: Getting more than one row in UNIQUE fields Tom Lane 17:36
Re: get sequence name from table name Gerardo Herzig 18:02
Re: get sequence name from table name Alvaro Herrera 19:24

Dec. 6, 2009

Thread Author Time
Re: Getting more than one row in UNIQUE fields Jasen Betts 08:55

Dec. 7, 2009

Thread Author Time
Query Performance Postgre Novice 13:00
Re: Query Performance tv 13:53
problems with changing the case of turkish characters the6campbells 17:12
Re: problems with changing the case of turkish characters Tom Lane 17:28
Re: problems with changing the case of turkish characters the6campbells 21:20
Re: problems with changing the case of turkish characters the6campbells 21:28

Dec. 8, 2009

Thread Author Time
Re: Query Performance Postgre Novice 07:55

Dec. 9, 2009

Thread Author Time
constants in 2-column foreign keys or how to design a storage for text-groups ? Andreas 00:20
Re: Stalled post to pgsql-sql sergey kapustin 10:30
Re: Stalled post to pgsql-sql Pavel Stehule 10:33
SQL state 58P01 triggered by a database script execution aymen marouani 13:10
Re: SQL state 58P01 triggered by a database script execution A. Kretschmer 13:24
Re: SQL state 58P01 triggered by a database script execution aymen marouani 13:33
Re: SQL state 58P01 triggered by a database script execution A. Kretschmer 13:46

Dec. 10, 2009

Thread Author Time
Window function trouble Harald Fuchs 17:00
Re: Window function trouble Harald Fuchs 17:49
Re: Window function trouble Tom Lane 18:09
Re: Window function trouble Harald Fuchs 21:02
Re: Window function trouble Tom Lane 23:08

Dec. 11, 2009

Thread Author Time
FIND_IN_SET Michael Eshom 06:22
Re: constants in 2-column foreign keys or how to design a storage for text-groups ? Jasen Betts 08:39
Re: FIND_IN_SET Pavel Stehule 08:48
Re: Re: constants in 2-column foreign keys or how to design a storage for text-groups ? Andreas 10:20
Re: Window function trouble Harald Fuchs 15:40
Is there any function to test for numeric ips? Oliveiros C, 16:05
Re: Is there any function to test for numeric ips? Fernando Hevia 16:20
Re: Is there any function to test for numeric ips? Harald Fuchs 16:23
Re: Is there any function to test for numeric ips? Fernando Hevia 16:26
Re: Is there any function to test for numeric ips? Alvaro Herrera 16:28
Re: Is there any function to test for numeric ips? Oliveiros C, 17:40

Dec. 16, 2009

Thread Author Time
8.3/8.4 SQL incompatibility? Britt Piehler 17:31
Re: 8.3/8.4 SQL incompatibility? Tom Lane 20:23

Dec. 17, 2009

Thread Author Time
get distinct + group by then filter Ivan Sergio Borgonovo 15:28

Dec. 18, 2009

Thread Author Time
Re: get distinct + group by then filter Filip Rembiałkowski 12:20
Re: get distinct + group by then filter Ivan Sergio Borgonovo 13:44

Dec. 21, 2009

Thread Author Time
8.4.1 distinct query WITHOUT order by Gary Chambers 22:15
Re: 8.4.1 distinct query WITHOUT order by Thomas Kellerer 22:38
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 22:53

Dec. 22, 2009

Thread Author Time
Re: 8.4.1 distinct query WITHOUT order by Gary Chambers 03:45
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 05:18
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 05:23
Re: 8.4.1 distinct query WITHOUT order by msi77 07:11
Re: 8.4.1 distinct query WITHOUT order by Scott Marlowe 09:22
short-cutting if sum()>constant Ivan Sergio Borgonovo 12:35
Re: short-cutting if sum()>constant Filip Rembiałkowski 13:48
Re: short-cutting if sum()>constant Adam Tauno Williams 14:02
Re: short-cutting if sum()>constant A. Kretschmer 14:12
Re: short-cutting if sum()>constant msi77 15:11
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 17:20
Re: short-cutting if sum()>constant Andreas Kretschmer 17:30
Re: short-cutting if sum()>constant msi77 19:15
Re: short-cutting if sum()>constant Pavel Stehule 19:47
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 23:00

Dec. 23, 2009

Thread Author Time
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 00:09
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 01:46
Re: short-cutting if sum()>constant Pavel Stehule 07:38
Using || operator to fold multiple columns into one Bryce Nesbitt 08:34
Re: Using || operator to fold multiple columns into one Craig Ringer 08:44
Re: Using || operator to fold multiple columns into one A. Kretschmer 08:50
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 10:56
Re: short-cutting if sum()>constant Pavel Stehule 11:52
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 13:01
Re: short-cutting if sum()>constant Pavel Stehule 13:35
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 14:27
Re: short-cutting if sum()>constant Craig Ringer 16:02
Re: short-cutting if sum()>constant Pavel Stehule 16:04
Re: short-cutting if sum()>constant Tom Lane 16:36
Re: short-cutting if sum()>constant Ivan Sergio Borgonovo 17:43
Re: short-cutting if sum()>constant Pavel Stehule 18:53
Re: Using || operator to fold multiple columns into one Rosser Schwarz 21:04

Dec. 24, 2009

Thread Author Time
Re: Using || operator to fold multiple columns into one Craig Ringer 03:08

Dec. 28, 2009

Thread Author Time
Invitation to connect on LinkedIn Mina Waheeb 16:57

Dec. 29, 2009

Thread Author Time
Foreign key - Indexing & Deadlocking. Andrew Hall 22:59
Re: Using || operator to fold multiple columns into one Bryce Nesbitt 23:44

Dec. 30, 2009

Thread Author Time
Re: Foreign key - Indexing & Deadlocking. Craig Ringer 01:18
DataBase Problem Premila Devi 01:49
Re: DataBase Problem Craig Ringer 01:54
Re: DataBase Problem Joshua Tolley 11:42
Re: PSQL statement to delete 100 rows meeting certain criteria Chris Browne 21:20

Dec. 31, 2009

Thread Author Time
loading a file into a field Brian Sherwood 16:23
Re: Using || operator to fold multiple columns into one Rosser Schwarz 16:23
Proper case function Michael Gould 17:36
Re: Proper case function Gary Chambers 17:40
Re: loading a file into a field Tim Landscheidt 18:15
Re: Proper case function Michael Gould 18:17
Re: Proper case function Tim Landscheidt 19:27
Re: Proper case function Seth Gordon 19:30

Jan. 1, 2010

Thread Author Time
Re: Proper case function Jasen Betts 10:39

Jan. 6, 2010

Thread Author Time
getting extract to always return number of hours Chris 01:33
Re: getting extract to always return number of hours Rosser Schwarz 01:50
Re: getting extract to always return number of hours Chris 02:48
Re: Proper case function John Summerfield 15:42
Fwd: conditional rule not applied Seb 20:40
Re: Fwd: conditional rule not applied Richard Broersma 21:01
Re: Fwd: conditional rule not applied Seb 21:31

Jan. 7, 2010

Thread Author Time
Re: Fwd: conditional rule not applied Leo Mannhart 15:31

Jan. 8, 2010

Thread Author Time
Re: Fwd: conditional rule not applied Seb 03:43

Jan. 9, 2010

Thread Author Time
how to do this query Wes James 04:26
Re: how to do this query Ian Barwick 09:07
Re: how to do this query msi77 11:36
Re: how to do this query msi77 22:52

Jan. 11, 2010

Thread Author Time
problem using regexp_replace gherzig 00:29
Re: problem using regexp_replace Jasen Betts 08:28
Re: problem using regexp_replace gherzig 10:33
CHECK constraint removing brackets Andy Shellam 19:49
Re: CHECK constraint removing brackets Scott Marlowe 20:14
Re: CHECK constraint removing brackets Tom Lane 20:15
Re: CHECK constraint removing brackets Andy Shellam 23:27

Jan. 12, 2010

Thread Author Time
Re: CHECK constraint removing brackets Tom Lane 00:10
Re: problem using regexp_replace Jasen Betts 12:10
Re: problem using regexp_replace gherzig 16:17

Jan. 15, 2010

Thread Author Time
rename primary key Seb 03:28
Re: rename primary key Ian Barwick 03:34
Re: rename primary key Seb 03:39
Re: rename primary key Guillaume Lelarge 06:35
indexes Seb 16:04
Re: rename primary key Seb 16:13

Jan. 17, 2010

Thread Author Time
Re: indexes Chris 21:59

Jan. 18, 2010

Thread Author Time
Re: indexes Seb 01:10
Re: indexes Craig Ringer 01:22

Jan. 19, 2010

Thread Author Time
How to cascade information like the user roles ? Andreas 00:33
Re: How to cascade information like the user roles ? Filip Rembiałkowski 14:27
Re: How to cascade information like the user roles ? Andreas 16:47

Jan. 20, 2010

Thread Author Time
Re: How to cascade information like the user roles ? 📎 Gurjeet Singh 05:45

Browse Archives

Prev | Next