pgsql-sql since 2011-01-15 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

Jan. 15, 2011

Thread Author Time
Re: why does seq scan instead of index scan 中川　誠貴 05:19
Re: why does seq scan instead of index scan Dmitriy Igrishin 16:36

Jan. 17, 2011

Thread Author Time
Re: why does seq scan instead of index scan 中川　誠貴 01:25
failing to connect to postgresql with php victor katemana 08:42
Re: failing to connect to postgresql with php Viktor Bojović 08:51
Re: failing to connect to postgresql with php Marcin Mirosław 09:23
Help needed in skipping column for copy command Amar Dhole 13:59
Re: Help needed in skipping column for copy command Adrian Klaver 20:46
Re: Help needed in skipping column for copy command Russell Galyon 21:14

Jan. 18, 2011

Thread Author Time
question about reg. expression andrew1 23:41

Jan. 19, 2011

Thread Author Time
Re: question about reg. expression Samuel Gendler 10:21
Re: question about reg. expression Stephen Belcher 13:17
Re: question about reg. expression Kenneth Marshall 14:18
Re: Getting top 2 by Category Carla 20:11
Re: Getting top 2 by Category Peter Steinheuser 20:59

Jan. 21, 2011

Thread Author Time
Issue with postgres connectivity Arindam Hore 10:45
Re: Issue with postgres connectivity Reinoud van Leeuwen 10:57
Re: Issue with postgres connectivity Arindam Hore 11:17
Re: Issue with postgres connectivity Arindam Hore 11:43
Re: Issue with postgres connectivity Edward W. Rouse 14:47

Jan. 22, 2011

Thread Author Time
Control reached end of trigger procedure without RETURN MoNiLlO 06:32
Re: Issue with postgres connectivity Jasen Betts 08:53
Re: question about reg. expression Jasen Betts 08:59
Control reached end of trigger procedure without RETURN Adelo Herrero Pérez 09:37
Re: Issue with postgres connectivity Arindam Hore 15:40
Re: Issue with postgres connectivity Arindam Hore 15:43

Jan. 24, 2011

Thread Author Time
loosing data in postgres database victor katemana 09:37
Postgres function for full text search - 09:38
Re: loosing data in postgres database Filip Rembiałkowski 09:49
Re: loosing data in postgres database Piotr Czekalski 09:51
Re: Postgres function for full text search Ivan Sergio Borgonovo 10:08

Jan. 25, 2011

Thread Author Time
check files .backup manuel antonio ochoa 00:18
Re: check files .backup Craig Ringer 05:45
Re: check files .backup Scott Marlowe 07:10
Re: Control reached end of trigger procedure without RETURN MoNiLlO 09:27
Re: Control reached end of trigger procedure without RETURN Adelo Herrero 09:33
Re: Control reached end of trigger procedure without RETURN Adelo 09:38
create geometry by lat/long gargdevender74 11:10
Queyring for columns which are exist in table. Santosh Bhujbal (sabhujba) 12:39
Re: Control reached end of trigger procedure without RETURN Tom Lane 15:06
Re: Control reached end of trigger procedure without RETURN MoNiLlO 15:21
Re: Control reached end of trigger procedure without RETURN MoNiLlO 15:22
Re: Control reached end of trigger procedure without RETURN Adelo 15:24
control function pgsql with script bash manuel antonio ochoa 16:46
Re: create geometry by lat/long Joshua Tolley 17:02
Re: control function pgsql with script bash Joshua Tolley 17:05
Benchmarking manuel antonio ochoa 17:39
Re: Benchmarking Scott Marlowe 18:20

Jan. 26, 2011

Thread Author Time
pgbench tools manuel antonio ochoa 00:34
Re: Queyring for columns which are exist in table. msi77 07:17
how to get row number in select query Emi Lu 16:11
Re: how to get row number in select query Oliveiros d'Azevedo Cristina 16:40
Re: how to get row number in select query Oliveiros d'Azevedo Cristina 17:02
Compare the resulta of a count sql into bash manuel antonio ochoa 17:07

Jan. 27, 2011

Thread Author Time
Re: check files .backup Craig Ringer 00:11
Re: Compare the resulta of a count sql into bash Josh Kupershmidt 04:49
Re: Compare the resulta of a count sql into bash Scott Marlowe 06:11
Queyring for columns which are exist in table. Santosh Bhujbal (sabhujba) 07:52
Re: Queyring for columns which are exist in table. Thom Brown 09:38
Re: Queyring for columns which are exist in table. Santosh Bhujbal (sabhujba) 09:53
Re: Queyring for columns which are exist in table. Thom Brown 10:08
Re: Compare the resulta of a count sql into bash Jasen Betts 10:20
Re: Queyring for columns which are exist in table. Sim Zacks 10:56
Re: Queyring for columns which are exist in table. Sim Zacks 14:15
Re: how to get row number in select query Emi Lu 14:32
Re: how to get row number in select query Oliveiros d'Azevedo Cristina 15:02
Re: how to get row number in select query Piotr Czekalski 15:21
Re: how to get row number in select query Thomas Kellerer 15:30
Automating PostgreSql table partition using triggers Amitabh Kant 17:50
Re: Automating PostgreSql table partition using triggers Amitabh Kant 17:52
Re: Automating PostgreSql table partition using triggers Viktor Bojović 21:10
Re: Automating PostgreSql table partition using triggers Scott Marlowe 21:27

Jan. 28, 2011

Thread Author Time
Re: Automating PostgreSql table partition using triggers Amitabh Kant 02:41
Re: Automating PostgreSql table partition using triggers Amitabh Kant 02:47
aggregation of setof Andreas Gaab 11:42

Jan. 29, 2011

Thread Author Time
something simple but I can't John Fabiani 01:16
Re: something simple but I can't Jasen Betts 03:46
Re: something simple but I can't John Fabiani 15:14

Jan. 31, 2011

Thread Author Time
Re: aggregation of setof Andreas Gaab 08:52
Re: aggregation of setof Pavel Stehule 09:23
Re: aggregation of setof Andreas Gaab 10:22
fix uuid contrib module for Windows 64 Michael Gould 13:40
Re: aggregation of setof Tom Lane 15:32
Re: aggregation of setof Viktor Bojović 15:37
Get days between two dates? Emi Lu 15:50
Re: Get days between two dates? Tovo J. RABEMANANTSOA 16:29
Re: Get days between two dates? Oliveiros d'Azevedo Cristina 16:33
Re: Get days between two dates? Emi Lu 16:36
Re: Get days between two dates? Kenneth Marshall 16:39
Re: how to get row number in select query Emi Lu 16:39
Re: Get days between two dates? Oliveiros d'Azevedo Cristina 16:51

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

Browse Archives

Prev | Next