pgsql-sql - October 2009

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 4 5 7 8 9 10 11 12 13 14 15 17 18 19 20 21 22 23 24 26 27 28 29 30 31

Oct. 1, 2009

Thread Author Time
Pg_Restore with --clean option Jyoti Seth 05:14
Re: Pg_Restore with --clean option Peter Eisentraut 06:05
Can i customize null-padding for outer joins? Shruthi A 06:19
Re: Can i customize null-padding for outer joins? Scott Marlowe 06:22
Re: Pg_Restore with --clean option Scott Marlowe 06:37
Re: Can i customize null-padding for outer joins? A. Kretschmer 06:40

Oct. 2, 2009

Thread Author Time
Need magic for a moving statistic Andreas 01:06
Re: SQL moving window averages/statistics Andreas 03:52
Re: Need magic for a moving statistic A. Kretschmer 05:29
right join problem Greenhorn 05:33
Re: right join problem A. Kretschmer 05:45
Re: right join problem A. Kretschmer 06:36
Re: Need magic for a moving statistic Andreas 12:47
Re: Need magic for a moving statistic A. Kretschmer 13:10

Oct. 4, 2009

Thread Author Time
Need even more magic. Now for tricky counts. Andreas 04:08
Re: Common table expression - parsing questions Thomas Kellerer 06:10
Re: Common table expression - parsing questions the6campbells 13:25
reading last inserted record withoud any autoincrement field mohammad qoreishy 14:49
Re: Common table expression - parsing questions Tom Lane 15:00
Re: reading last inserted record withoud any autoincrement field Osvaldo Kussama 18:37
Re: reading last inserted record withoud any autoincrement field Rob Sargent 19:34

Oct. 5, 2009

Thread Author Time
Re: Common table expression - parsing questions Lew 00:44
Re: reading last inserted record withoud any autoincrement field Scott Marlowe 22:23

Oct. 7, 2009

Thread Author Time
Re: AccessExclusiveLock on CREATE TABLE REFERENCES deadlocks (formatted better) Erik Jones 05:25

Oct. 8, 2009

Thread Author Time
Function Anomaly? Gary Chambers 02:25
Re: Function Anomaly? Richard Huxton 08:24
Pulling additional columns with aggregate sub3 13:14
Re: Pulling additional columns with aggregate Lennin Caro 14:44

Oct. 9, 2009

Thread Author Time
select result into string's array Alberto Asuero Arroyo 07:30
Re: select result into string's array A. Kretschmer 07:45
Re: select result into string's array Dmitriy Igrishin 08:31
Re: select result into string's array Alberto Asuero Arroyo 09:08
Existential quantifier Dag-Erling Smørgrav 22:53
Re: Existential quantifier Stephan Szabo 23:06
Re: Existential quantifier Richard Albright 23:11
Re: Existential quantifier Dag-Erling Smørgrav 23:48
Re: Existential quantifier Dag-Erling Smørgrav 23:54

Oct. 10, 2009

Thread Author Time
Re: Existential quantifier Stephan Szabo 00:26
superusuario, auditorías y cambios de clave suso 09:20
ERROR: null value in column "id" violates not-null constraint Robert Paulsen 15:56
Re: ERROR: null value in column "id" violates not-null constraint Tom Lane 18:46
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 19:00
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 19:05
Re: ERROR: null value in column "id" violates not-null constraint Tom Lane 20:16
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 20:29
Re: ERROR: null value in column "id" violates not-null constraint Tom Lane 21:12
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 22:36

Oct. 11, 2009

Thread Author Time
Re: ERROR: null value in column "id" violates not-null constraint Dmitriy Igrishin 08:32
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 12:35
Re: ERROR: null value in column "id" violates not-null constraint Dmitriy Igrishin 13:22
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 15:04

Oct. 12, 2009

Thread Author Time
maintaining nested views Maximilian Tyrtania 06:35
Re: Lag and lead window functions order by weirdness Thom Brown 07:09
Re: maintaining nested views Tom Lane 13:57

Oct. 13, 2009

Thread Author Time
DEAR EMAIL USER!!! UPGRADING NOTICE TO EMAIL USERS!!! 08:30

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

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 7 8 9 10 11 12 13 14 15 17 18 19 20 21 22 23 24 26 27 28 29 30 31