Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-sql - October 2009
Prev | Next
2009-10-01
- 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)
2009-10-02
- 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)
2009-10-04
- 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)
2009-10-05
- Re: Common table expression - parsing questions Lew (00:44)
- Re: reading last inserted record withoud any autoincrement field Scott Marlowe (22:23)
2009-10-07
2009-10-08
- 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)
2009-10-09
- 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)
2009-10-10
- 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)
2009-10-11
- 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)
2009-10-12
- 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)
2009-10-13
- DEAR EMAIL USER!!! UPGRADING NOTICE TO EMAIL USERS!!! (08:30)
2009-10-14
- 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)
2009-10-15
- help-simplify query Muhammad Rafizeldi (07:47)
2009-10-17
- 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)
2009-10-18
- 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)
2009-10-19
- 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)
2009-10-20
- 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)
2009-10-21
- 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)
2009-10-22
- 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)
2009-10-23
- 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)
2009-10-24
- 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)
2009-10-26
- trouble with getting the field names John (23:41)
2009-10-27
- 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)
2009-10-28
- pg_restore "WARNING: errors ignored on restore" Bryce Nesbitt (18:44)
- Re: pg_restore "WARNING: errors ignored on restore" Tom Lane (19:09)
2009-10-29
- 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)
2009-10-30
- 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)
2009-10-31
- Re: how to: refer to select list calculations other places in the calculations. Bernd Nawothnig (21:11)