pgsql-sql since 2011-02-06 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

Feb. 6, 2011

Thread Author Time
Re: TABLE PARTITION Vibhor Kumar 12:10

Feb. 7, 2011

Thread Author Time
Re: PosgreSQL - TSQL2 question Craig Ringer 03:12
Cumulative result with increment Shawn Tayler 21:11
Re: Cumulative result with increment Steve Crawford 22:13

Feb. 8, 2011

Thread Author Time
why SELECT query needs relationname (schemaName.tableName) Amar Dhole 06:56
Re: why SELECT query needs relationname (schemaName.tableName) Samuel Gendler 07:16
UTF characters compromising data import. Gavin Beau Baumanis 10:03
Re: UTF characters compromising data import. Pavel Stehule 10:20
Get postgresql server ip address Gera Mel Handumon 10:28
Re: Get postgresql server ip address Dmitriy Igrishin 14:56
Re: Get postgresql server ip address Chris Browne 15:30
Re: Cumulative result with increment Shawn Tayler 18:09
data import: 12-hour time w/o AM/PM Tarlika Elisabeth Schmitz 18:14
Re: data import: 12-hour time w/o AM/PM Leif Biberg Kristensen 18:25
Re: data import: 12-hour time w/o AM/PM Oliveiros d'Azevedo Cristina 18:38
Re: data import: 12-hour time w/o AM/PM Andrej 19:21
Re: data import: 12-hour time w/o AM/PM Tarlika Elisabeth Schmitz 19:27
"select c1, method(c2) group by c1" returns all values of c2 for c1 Emi Lu 19:35
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Pavel Stehule 19:43
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Peter Steinheuser 19:43
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Rolando Edwards 19:51
Re: data import: 12-hour time w/o AM/PM 📎 Tarlika Elisabeth Schmitz 19:55
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Emi Lu 20:09
Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 Pavel Stehule 20:14

Feb. 10, 2011

Thread Author Time
DELETE FROM takes forever Josh 17:57
Re: DELETE FROM takes forever Hiltibidal, Rob 18:13
Re: DELETE FROM takes forever Piotr Czekalski 18:36
Re: DELETE FROM takes forever Samuel Gendler 18:37
Re: DELETE FROM takes forever Tom Lane 18:44
Re: DELETE FROM takes forever Chris Browne 18:51
Re: DELETE FROM takes forever Josh 19:15

Feb. 11, 2011

Thread Author Time
Drawing a blank on some SQL Aaron Burnett 18:46
Re: Drawing a blank on some SQL Peter Steinheuser 19:11
Re: Drawing a blank on some SQL Rob Sargent 19:17
Re: Drawing a blank on some SQL Samuel Gendler 19:22
Re: Drawing a blank on some SQL Osvaldo Kussama 20:09
Re: Drawing a blank on some SQL Aaron Burnett 20:47

Feb. 12, 2011

Thread Author Time
Re: Drawing a blank on some SQL Samuel Gendler 00:55
Re: DELETE FROM takes forever Jasen Betts 08:09
Re: UTF characters compromising data import. Jasen Betts 09:15

Feb. 13, 2011

Thread Author Time
Re: UTF characters compromising data import. Gavin Beau Baumanis 11:08

Feb. 14, 2011

Thread Author Time
SQL gotcha Dean Gibson (DB Administrator) 23:29

Feb. 15, 2011

Thread Author Time
Re: SQL gotcha Achilleas Mantzios 07:41
Determine length of numeric field Tony Capobianco 20:48
Re: Determine length of numeric field Pavel Stehule 21:04
Re: Determine length of numeric field Peter Steinheuser 21:08
Re: Determine length of numeric field Tony Capobianco 21:09
Re: Determine length of numeric field Tom Lane 21:10
Re: Determine length of numeric field Tony Capobianco 21:14
recommended data model for a search? Mark Stosberg 22:04
Re: Determine length of numeric field Jasen Betts 23:32

Feb. 16, 2011

Thread Author Time
PL/SQL block error Sivannarayanreddy 08:42
Re: PL/SQL block error Pavel Stehule 09:07
Oracle Equivalent queries in Postgres Sivannarayanreddy 10:42
Re: Oracle Equivalent queries in Postgres Pavel Stehule 10:50
Re: Oracle Equivalent queries in Postgres Thomas Kellerer 11:04
Re: Oracle Equivalent queries in Postgres Pavel Stehule 11:17
Re: Oracle Equivalent queries in Postgres Pavel Stehule 11:20
Re: Oracle Equivalent queries in Postgres Thomas Kellerer 11:33
Function compile error Sivannarayanreddy 12:35
Re: Function compile error Pavel Stehule 12:49
Re: Oracle Equivalent queries in Postgres Tom Lane 15:11
Retrieve the column values of a record without knowing the names arthur_info 16:16
Retrieve the column values of a record without knowing the names arthur_info 16:18
Re: Function compile error Igor Neyman 16:24
After insert trigger and select Rok Jaklič 17:12
Re: Oracle Equivalent queries in Postgres bricklen 17:28
Re: After insert trigger and select pasman pasmański 19:46
Re: After insert trigger and select Rok Jaklič 22:34

Feb. 17, 2011

Thread Author Time
Is it possible to get DISTINCT rows from RETURNING clause? Gnanakumar 07:05
ARRAY_AGG and COUNT Andreas Forø Tollefsen 14:20
Re: After insert trigger and select Igor Neyman 16:37
Re: ARRAY_AGG and COUNT bricklen 19:21
Re: ARRAY_AGG and COUNT Andreas Forø Tollefsen 20:11
Re: ARRAY_AGG and COUNT bricklen 22:54

Feb. 18, 2011

Thread Author Time
Re: Function compile error Sivannarayanreddy 05:44
Re: Is it possible to get DISTINCT rows from RETURNING clause? Gnanakumar 05:58
Re: Retrieve the column values of a record without knowing the names Pavel Stehule 08:34
Re: Retrieve the column values of a record without knowing the names Achilleas Mantzios 09:10
Re: Retrieve the column values of a record without knowing the names arthur_info 11:46
Re: Retrieve the column values of a record without knowing the names arthur_info 11:47
Re: Retrieve the column values of a record without knowing the names arthur_info 11:59

Feb. 19, 2011

Thread Author Time
Re: Retrieve the column values of a record without knowing the names Dmitriy Igrishin 09:47
Re: Is it possible to get DISTINCT rows from RETURNING clause? Dmitriy Igrishin 10:00

Feb. 21, 2011

Thread Author Time
Re: Is it possible to get DISTINCT rows from RETURNING clause? Gnanakumar 11:50

Feb. 22, 2011

Thread Author Time
replace_matches does not return {null} Andreas Gaab 11:25
Re: replace_matches does not return {null} Tom Lane 16:39
Re: Retrieve the column values of a record without knowing the names arthur_info 19:39
quotes etc John Fabiani 20:26
Re: quotes etc Kenneth Marshall 20:48
Re: quotes etc Adrian Klaver 21:18

Feb. 23, 2011

Thread Author Time
Re: quotes etc Emi Lu 19:11
Function To Strip HTML Ozer, Pam 23:41

Feb. 24, 2011

Thread Author Time
Compare two Data bases Structure manuel antonio ochoa 00:03
Re: Compare two Data bases Structure Plugge, Joe R. 00:09
Re: Function To Strip HTML Ozer, Pam 00:17
Re: Compare two Data bases Structure Piotr Czekalski 09:18
Re: Compare two Data bases Structure Vibhor Kumar 10:02
Re: Compare two Data bases Structure Isaac Dover 13:48
Problem with serial counters Jacques Lebrun 21:09
Re: Compare two Data bases Structure Isaac Dover 22:51

Feb. 25, 2011

Thread Author Time
what's wrong in this procedure? Camaleon 17:46
Re: what's wrong in this procedure? Adrian Klaver 18:33
Re: what's wrong in this procedure? Yeb Havinga 18:38
Re: Problem with serial counters Vibhor Kumar 18:47
Re: what's wrong in this procedure? Rob Sargent 21:39

March 1, 2011

Thread Author Time
Re: what's wrong in this procedure? Vibhor Kumar 07:56
distinguishing identical columns after joins S G 19:47
Re: distinguishing identical columns after joins Rob Sargent 19:53
Re: Problem with serial counters Richard Huxton 20:29
Re: distinguishing identical columns after joins S G 22:13
Re: distinguishing identical columns after joins Rob Sargent 23:00
Re: distinguishing identical columns after joins Stephen Cook 23:37
Re: distinguishing identical columns after joins Lee Hachadoorian 23:44

March 2, 2011

Thread Author Time
Re: distinguishing identical columns after joins S G 13:45
Re: distinguishing identical columns after joins S G 14:24

March 7, 2011

Thread Author Time
A function to count all ocurrences of a character within a string. Piotr Czekalski 21:20
Re: A function to count all ocurrences of a character within a string. bricklen 22:08
Re: A function to count all ocurrences of a character within a string. Ross J. Reedstrom 22:32

March 9, 2011

Thread Author Time
How to transform table rows into Colum? Eric Ndengang 17:16
Re: How to transform table rows into Colum? Dmitriy Igrishin 18:07
plpgsql exception handling Uwe Bartels 21:55
Re: plpgsql exception handling Samuel Gendler 22:08

March 10, 2011

Thread Author Time
Re: plpgsql exception handling bricklen 00:20
Re: plpgsql exception handling Uwe Bartels 08:45
Re: plpgsql exception handling Uwe Bartels 08:45
Re: plpgsql exception handling Samuel Gendler 09:56
Re: plpgsql exception handling Uwe Bartels 10:53
Re: plpgsql exception handling Samuel Gendler 18:27
Re: plpgsql exception handling Uwe Bartels 18:38

March 17, 2011

Thread Author Time
Bizarreness at A2 Hosting Good, Thomas 16:26
Re: Bizarreness at A2 Hosting John DeSoi 17:05
Re: How to transform table rows into Colum? Richard Albright 17:12
Re: Bizarreness at A2 Hosting Good, Thomas 17:27

March 21, 2011

Thread Author Time
Obscure behavior of ORDER BY Tambet Matiisen 09:29

March 23, 2011

Thread Author Time
xml2 support Rob Sargent 16:52
xml2 support Rob Sargent 17:05
Re: xml2 support Serdar Gül 17:10
Re: xml2 support Rob Sargent 18:00
Re: xml2 support Serdar Gül 18:56
Re: Obscure behavior of ORDER BY Pavel Stehule 21:09
Re: converting big int to date Sree 21:12
pg_attributte, data types Viktor Bojović 23:05
Re: pg_attributte, data types Tom Lane 23:56

March 24, 2011

Thread Author Time
Re: xml2 support Isaac T. Dover 05:21
Re: pg_attributte, data types Viktor Bojović 07:49
Re: converting big int to date Vibhor Kumar 16:30

March 26, 2011

Thread Author Time
Re: converting big int to date Jasen Betts 10:04

March 27, 2011

Thread Author Time
Re: converting big int to date Jasen Betts 08:32

March 31, 2011

Thread Author Time
Aggregates puzzle 📎 Mark Fenbers 20:15
Re: Aggregates puzzle Ozer, Pam 23:14

April 5, 2011

Thread Author Time
is there a refactor John Fabiani 14:27
Re: is there a refactor Viktor Bojović 14:39
Re: is there a refactor Adrian Klaver 14:44
Re: is there a refactor Peter Steinheuser 14:49
Re: is there a refactor John Fabiani 14:58

April 8, 2011

Thread Author Time
Re: Aggregates puzzle msi77 10:21
Capture insert returning 14:18

April 12, 2011

Thread Author Time
pass in array to function for use by where clause? how optimize? Anish Kejariwal 17:08

April 13, 2011

Thread Author Time
unnesting of array of different size explodes memory Andreas Gaab 09:15
Re: unnesting of array of different size explodes memory Tom Lane 14:52
Re: pass in array to function for use by where clause? how optimize? Tom Lane 15:09
Re: pass in array to function for use by where clause? how optimize? Rob Sargent 15:48
Re: pass in array to function for use by where clause? how optimize? Tom Lane 16:15
Re: [SQL] unnesting of array of different size explodes memory Charlie 16:21
Re: pass in array to function for use by where clause? how optimize? Anish Kejariwal 19:03
strange update behavior Volkmar Herbst GCI 19:59

April 14, 2011

Thread Author Time
Get id of a tuple using exception f vf 10:56
Re: Get id of a tuple using exception Adrian Klaver 13:23
Re: Get id of a tuple using exception Adrian Klaver 14:32
update with recursive query Steven Dahlin 21:33
update using recursion Steven Dahlin 21:53

April 15, 2011

Thread Author Time
convert in GMT time zone without summer time LaraK 06:20
Re: update with recursive query Pavel Stehule 06:46

April 16, 2011

Thread Author Time
Re: convert in GMT time zone without summer time Jasen Betts 12:02
Re: Get id of a tuple using exception Jasen Betts 12:13

April 18, 2011

Thread Author Time
Re: convert in GMT time zone without summer time LaraK 07:10
Re: convert in GMT time zone without summer time Steve Crawford 16:56

April 20, 2011

Thread Author Time
[No subject] Humair Mohammed 14:45
How to realize ROW_NUMBER() in 8.3? Emi Lu 15:45
Re: How to realize ROW_NUMBER() in 8.3? Vibhor Kumar 16:06
Re: How to realize ROW_NUMBER() in 8.3? Oliveiros d'Azevedo Cristina 16:12
help on select Saulo Venâncio 20:10

April 21, 2011

Thread Author Time
Re: help on select Charlie 08:03
Re: Tom Lane 14:34
Re: help on select Jasen Betts 23:15

April 28, 2011

Thread Author Time
Select For Update and Left Outer Join Patrick Earl 06:00
[No subject] Ricardo Benatti 21:26

May 1, 2011

Thread Author Time
Multiple recursive part possible? Svenne Krap 19:45
Re: Multiple recursive part possible? Tom Lane 22:12

May 2, 2011

Thread Author Time
Re: Multiple recursive part possible? Svenne Krap 03:18
BINARY and BINARY VARYING datatypes in PostgreSQL Grzegorz Szpetkowski 10:46
getting PSQLException Can't infer the SQL type to use with Native Query call Steven Dahlin 15:17
FATAL: invalid cache id: 19 manuel antonio ochoa 15:38
Re: FATAL: invalid cache id: 19 Tom Lane 16:25
Re: getting PSQLException Can't infer the SQL type to use with Native Query call Tom Lane 16:30
PLpgSQL variables persistance between several functions calls Charles N. Charotti 21:43

May 3, 2011

Thread Author Time
Re: [SQL] PLpgSQL variables persistance between several functions calls Pavel Stehule 02:10
Re: convert in GMT time zone without summer time LaraK 07:15
checking for the existence of a current_setting ? Marc Mamin 08:07

Browse Archives

Prev | Next