pgsql-sql - February 2011

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 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25

Feb. 1, 2011

Thread Author Time
TABLE PARTITION NEVIN ALEX 13:31
Re: fix uuid contrib module for Windows 64 Hiroshi Saito 15:49

Feb. 2, 2011

Thread Author Time
How to checking the existance of constraints for a table? creationw 20:40
How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1? creationw 22:21

Feb. 3, 2011

Thread Author Time
Transaction-specific global variable Florian Weimer 09:10
out of shared memory - find temporary tables Sabin Coanda 10:52
how control update rows Sabin Coanda 11:01
UNIQUE on everything except primary key gvim 15:44
Re: UNIQUE on everything except primary key Andreas Gaab 15:48
Re: Transaction-specific global variable Tom Lane 16:31
using of select (myfunction()).* is so slow Gerardo Herzig 18:40
Re: using of select (myfunction()).* is so slow Pavel Stehule 19:47

Feb. 4, 2011

Thread Author Time
Re: UNIQUE on everything except primary key msi77 07:02
Re: how control update rows Pavel Stehule 07:18
Re: How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1? Viktor Bojović 08:33
Re: using of select (myfunction()).* is so slow Gerardo Herzig 10:51
Re: using of select (myfunction()).* is so slow Pavel Stehule 11:17
Re: using of select (myfunction()).* is so slow Gerardo Herzig 12:05
Re: How to checking the existance of constraints for a table? bricklen 16:38

Feb. 5, 2011

Thread Author Time
PosgreSQL - TSQL2 question Sarbu Anca 22:26

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25