pgsql-sql since 2009-10-14 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. 14, 2009

Thread Author Time
How to get the previous date? Shruthi A 09:40
Re: How to get the previous date? Dmitriy Igrishin 09:43
Re: How to get the previous date? ramasubramanian 10:00
How to order varchar data by word Oliveiros C, 14:13
Re: How to get the previous date? msi77 20:41
Re: How to order varchar data by word Adrian Klaver 20:54

Oct. 15, 2009

Thread Author Time
help-simplify query Muhammad Rafizeldi 07:47

Oct. 17, 2009

Thread Author Time
Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Gary Chambers 02:27
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Rob Sargent 03:21
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function matthias schoeneich 11:29
Re: How to get the previous date? Jasen Betts 11:41

Oct. 18, 2009

Thread Author Time
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Rob Sargent 05:26
Re: Lag and lead window functions order by weirdness Tim Landscheidt 16:51

Oct. 19, 2009

Thread Author Time
Re: How to order varchar data by word Oliveiros C, 17:07
Re: How to order varchar data by word Tom Lane 17:32
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Gary Chambers 21:54
Dynamic Query Andrew Hall 22:39
Re: Dynamic Query Tom Lane 22:55

Oct. 20, 2009

Thread Author Time
Re: How to order varchar data by word Oliveiros C, 13:39
Re: How to order varchar data by word Adrian Klaver 13:46
Re: How to order varchar data by word Oliveiros C, 15:54
Random Unique Id Nahuel Alejandro Ramos 19:49
Re: Random Unique Id Rob Sargent 19:53
Re: Random Unique Id Nahuel Alejandro Ramos 19:57
Re: Random Unique Id Rob Sargent 20:03
Re: Random Unique Id Nahuel Alejandro Ramos 20:14
Re: Random Unique Id Ivan Sergio Borgonovo 20:30
Re: Random Unique Id Craig Ringer 23:51

Oct. 21, 2009

Thread Author Time
report generation from table. sathiya psql 11:52
Re: report generation from table. A. Kretschmer 12:16
Re: report generation from table. Rob Sargent 14:48
@@Error equivalent in Postgresql maboyz 16:25
Re: @@Error equivalent in Postgresql Pavel Stehule 17:27
Re: @@Error equivalent in Postgresql maboyz 19:04

Oct. 22, 2009

Thread Author Time
Re: @@Error equivalent in Postgresql Pavel Stehule 02:32
Planner behaviour Sebastian 02:52
Re: @@Error equivalent in Postgresql Thomas Pundt 11:15
Problem with return type of function ??? Denis BUCHER 11:31
Re: Problem with return type of function ??? Richard Huxton 11:40
Re: Problem with return type of function ??? Denis BUCHER 11:49
Problem with return type of function ??? (corrected) Denis BUCHER 11:49
Re: Problem with return type of function ??? Richard Huxton 13:27
Re: Problem with return type of function ??? Denis BUCHER 13:29
Re: Problem with return type of function ??? Richard Huxton 13:46
Re: Problem with return type of function ??? Denis BUCHER 13:59
Re: Problem with return type of function ??? Richard Huxton 14:21
Re: Problem with return type of function ??? (corrected) Tom Lane 14:33
Re: Problem with return type of function ??? Denis BUCHER 14:34
Re: Problem with return type of function ??? (corrected) Denis BUCHER 14:38
Re: Problem with return type of function ??? Richard Huxton 14:58
Re: Problem with return type of function ??? (corrected) Richard Huxton 15:06
Re: Problem with return type of function ??? (corrected) Denis BUCHER 15:15
Re: Problem with return type of function ??? (corrected) Tom Lane 15:47
Re: Problem with return type of function ??? (corrected) Tom Lane 15:51
Assigning Values to Composite Types Gary Chambers 17:31
Re: Assigning Values to Composite Types Tom Lane 18:28
question about timestamp with tz the6campbells 20:41
date + interval year - why is the return type convered to a timestamp? the6campbells 21:04
Re: question about timestamp with tz Tom Lane 23:13
Re: date + interval year - why is the return type convered to a timestamp? Tom Lane 23:15
Re: question about timestamp with tz Scott Marlowe 23:26

Oct. 23, 2009

Thread Author Time
Re: @@Error equivalent in Postgresql Craig Ringer 10:59
Table Valued Parameters Andrew Hall 18:03
Re: Table Valued Parameters Pavel Stehule 18:10
FW: Table Valued Parameters Andrew Hall 18:22
Re: FW: Table Valued Parameters Brian Modra 18:32

Oct. 24, 2009

Thread Author Time
Re: Problem with return type of function ??? (corrected) Denis BUCHER 09:29
Re: Table Valued Parameters Andrew Hall 11:26
Re: Table Valued Parameters Richard Huxton 12:01
Re: Table Valued Parameters Brian Modra 12:12
Re: Table Valued Parameters Tom Lane 15:46

Oct. 26, 2009

Thread Author Time
trouble with getting the field names John 23:41

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

Browse Archives

Prev | Next