pgsql-sql since 2009-10-27 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

Oct. 27, 2009

Thread Author Time
Re: trouble with getting the field names John 02:02
record to columns: syntax question and strange behaviour Marc Mamin 16:08
Re: record to columns: syntax question and strange behaviour Thomas Pundt 17:20
Re: record to columns: syntax question and strange behaviour Marc Mamin 18:46

Oct. 28, 2009

Thread Author Time
pg_restore "WARNING: errors ignored on restore" Bryce Nesbitt 18:44
Re: pg_restore "WARNING: errors ignored on restore" Tom Lane 19:09

Oct. 29, 2009

Thread Author Time
Using information_schema to find about function parameters? Mario Splivalo 16:51
Re: Using information_schema to find about function parameters? Thomas Kellerer 17:20
Speed up UPDATE query? Lee Hachadoorian 17:50
Re: pg_restore "WARNING: errors ignored on restore" Gerardo Herzig 18:04
Re: slow count(CASE) query Gerardo Herzig 18:14
slow count(CASE) query Grant Masan 18:27
Re: slow count(CASE) query Rob Sargent 21:49
pg_get_functiondef and overloaded functions Thomas Kellerer 23:12

Oct. 30, 2009

Thread Author Time
Re: pg_get_functiondef and overloaded functions Tom Lane 04:44
Re: slow count(CASE) query Richard Huxton 08:40
Function Syntax Help Plugge, Joe R. 19:14
Re: Function Syntax Help Brian Modra 19:29
Re: Function Syntax Help Plugge, Joe R. 19:30
Re: Function Syntax Help Brian Modra 19:45
Re: Function Syntax Help Plugge, Joe R. 19:50
Re: Function Syntax Help Tom Lane 21:22
Re: pg_get_functiondef and overloaded functions Thomas Kellerer 23:46

Oct. 31, 2009

Thread Author Time
Re: how to: refer to select list calculations other places in the calculations. Bernd Nawothnig 21:11

Nov. 1, 2009

Thread Author Time
Re: Speed up UPDATE query? Scott Marlowe 00:08
PostgreSQL Security/Roles/Grants Andrew Hall 18:04
Re: PostgreSQL Security/Roles/Grants Stephen Frost 19:09

Nov. 2, 2009

Thread Author Time
Re: PostgreSQL Security/Roles/Grants Jasen Betts 10:11

Nov. 4, 2009

Thread Author Time
Why don't I get a LATIN1 encoding here with SET ENCODING? 📎 Bryce Nesbitt 01:13
Re: Why don't I get a LATIN1 encoding here with SET ENCODING? Craig Ringer 02:29
Re: Why don't I get a LATIN1 encoding here with SET ENCODING? Bryce Nesbitt 03:36
Re: Why don't I get a LATIN1 encoding here with SET ENCODING? Craig Ringer 03:47
Re: Why don't I get a LATIN1 encoding here with SET ENCODING? Bryce Nesbitt 03:54
Re: Why don't I get a LATIN1 encoding here with SET ENCODING? Craig Ringer 04:25
Re: Why don't I get a LATIN1 encoding here with SET ENCODING? Craig Ringer 04:34
DDL problems: Referential issue? Leif Biberg Kristensen 18:03
Re: DDL problems: Referential issue? Scott Marlowe 18:24
Re: DDL problems: Referential issue? Leif Biberg Kristensen 18:36
Re: DDL problems: Referential issue? Scott Marlowe 18:37
Re: DDL problems: Referential issue? Leif Biberg Kristensen 18:53
Re: DDL problems: Referential issue? Scott Marlowe 20:03
Re: DDL problems: Referential issue? Leif Biberg Kristensen 20:14
Re: DDL problems: Referential issue? Scott Marlowe 20:25
Mangled high bit characters with pg_server_prepare=0 in DBD::Pg Bryce Nesbitt 21:00
Learning about WITH RECURSIVE Richard Broersma 22:03
Re: Learning about WITH RECURSIVE Tom Lane 22:11
Re: Learning about WITH RECURSIVE Richard Broersma 22:17
Re: Learning about WITH RECURSIVE Richard Broersma 22:27

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

Browse Archives

Prev | Next