pgsql-sql before 2011-01-24 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

Nov. 30, 2010

Thread Author Time
Re: Deleting entries from multiple tables Dusan Misic 08:19
Re: Deleting entries from multiple tables Achilleas Mantzios 08:36
Re: Deleting entries from multiple tables manidegr8 10:00
Re: subselect and left join not working? Carla 13:22
Re: Is there a solution for "SELECT OR INSERT" Florian Weimer 14:16
indexing longish string Rob Sargent 17:42
Re: indexing longish string jose 17:50
Re: indexing longish string Rob Sargent 17:57
Re: indexing longish string Kenneth Marshall 18:36
Re: indexing longish string Isaac Dover 19:21
Re: How strings are sorted by LC_COLLATE specifically? Peter Eisentraut 19:31
Re: indexing longish string Isaac Dover 20:03
DELETE WHERE EXISTS unexpected results Jeff Bland 22:16

Dec. 1, 2010

Thread Author Time
aggregation question Samuel Gendler 03:47
OT - load a shp file John Fabiani 06:06
Re: aggregation question Samuel Gendler 09:06
Re: OT - load a shp file Lee Hachadoorian 09:13
Re: DELETE WHERE EXISTS unexpected results Carla 13:05
Re: OT - load a shp file John Fabiani 14:29
Re: How strings are sorted by LC_COLLATE specifically? Chang Chao 14:31
Re: DELETE WHERE EXISTS unexpected results Jeff Bland 15:07

Dec. 2, 2010

Thread Author Time
Re: DELETE WHERE EXISTS unexpected results Jasen Betts 07:47
COPY with FORMAT in Postgresql 9.x Humair Mohammed 21:45
Calculate next event date based on instance of the day of week Dimitri 21:46

Dec. 3, 2010

Thread Author Time
Re: Calculate next event date based on instance of the day of week Jayadevan M 06:17
Get the max viewd product_id for user_id Mario Splivalo 10:53
Re: Get the max viewd product_id for user_id Jayadevan M 11:40
Re: COPY with FORMAT in Postgresql 9.x Tom Lane 15:51
Union Question Shaun McCloud 16:51
Re: Union Question Plugge, Joe R. 16:58
Re: Union Question Shaun McCloud 17:04
Re: Union Question Christophe Pettus 17:08
Re: Union Question Shaun McCloud 17:08
Re: Union Question Christophe Pettus 17:27
Re: Union Question Shaun McCloud 17:30
A note on how to generate a list of months within some period of time. Michał Roszka 21:00
Re: Union Question Jasen Betts 23:20

Dec. 5, 2010

Thread Author Time
Re: Get the max viewd product_id for user_id Mario Splivalo 16:48
Re: Get the max viewd product_id for user_id Mario Splivalo 16:57
Re: Get the max viewd product_id for user_id Mario Splivalo 16:59

Dec. 6, 2010

Thread Author Time
Re: Get the max viewd product_id for user_id Jayadevan M 02:55
First aggregate with null support Marc Mamin 10:59
The best option to insert data with primary id - 14:59
Re: The best option to insert data with primary id mike 15:27
Re: The best option to insert data with primary id mike 16:21
Re: Union Question bricklen 19:39

Dec. 7, 2010

Thread Author Time
concatenate question Tony Capobianco 21:07
concatenate question Tony Capobianco 21:37
Re: concatenate question Peter Steinheuser 21:43
Re: concatenate question Tony Capobianco 21:47
Re: concatenate question Dmitriy Igrishin 21:51
Re: concatenate question Kenneth Marshall 21:52
Re: concatenate question Richard Broersma 21:53
Re: concatenate question Peter Steinheuser 21:54

Dec. 8, 2010

Thread Author Time
mybatis 3 RETURNING id problem with insert. - 07:27
conditional aggregates Marcin Krawczyk 12:49
Re: conditional aggregates Pavel Stehule 13:07
Re: conditional aggregates Marcin Krawczyk 13:19
Regular Expression Match Operator escape character Gnanakumar 13:51
Re: conditional aggregates Marc Mamin 14:06
Re: concatenate question Tony Capobianco 14:08
Re: conditional aggregates Marcin Krawczyk 14:35

Dec. 9, 2010

Thread Author Time
Re: concatenate question Edgardo Portal 16:16
Extended query protocol and exact types matches. Dmitriy Igrishin 18:24
Correct usage of FOR UPDATE? Joe Carr 19:29
sqlplus reporting equivalent in postgres? Tony Capobianco 21:47
Fwd: Extended query protocol and exact types matches. Dmitriy Igrishin 22:10

Dec. 10, 2010

Thread Author Time
Fwd: Extended query protocol and exact types matches. Dmitriy Igrishin 07:53
Re: Fwd: Extended query protocol and exact types matches. Robert Haas 16:16
Re: Fwd: Extended query protocol and exact types matches. Dmitriy Igrishin 16:46
Re: Extended query protocol and exact types matches. Merlin Moncure 17:22
Re: Extended query protocol and exact types matches. Dmitriy Igrishin 17:40
Re: Fwd: Extended query protocol and exact types matches. Robert Haas 17:51
Re: Fwd: Extended query protocol and exact types matches. Dmitriy Igrishin 17:58
Re: Extended query protocol and exact types matches. Merlin Moncure 18:05
Re: Extended query protocol and exact types matches. Dmitriy Igrishin 18:26

Dec. 11, 2010

Thread Author Time
Re: sqlplus reporting equivalent in postgres? Igor Neyman 01:44
Re: sqlplus reporting equivalent in postgres? Samuel Gendler 03:23
Re: sqlplus reporting equivalent in postgres? Gary Chambers 03:28
Re: sqlplus reporting equivalent in postgres? Samuel Gendler 03:44
Re: The best option to insert data with primary id Jasen Betts 10:17
Re: Correct usage of FOR UPDATE? Dmitriy Igrishin 10:32
Re: sqlplus reporting equivalent in postgres? Thomas Kellerer 10:50
Re: concatenate question Andreas Kretschmer 13:42

Dec. 13, 2010

Thread Author Time
Re: Regular Expression Match Operator escape character Jasen Betts 09:18
constraint with check Viktor Bojović 23:36

Dec. 14, 2010

Thread Author Time
Aggregating by unique values Lee Hachadoorian 05:11
Re: constraint with check Jasen Betts 07:12
Re: Using count on a join, group by required? emaratiyya 07:19
Re: Aggregating by unique values Filip Rembiałkowski 08:23
Re: Using count on a join, group by required? Trinath Somanchi 08:53
Re: Using count on a join, group by required? Rob Sargent 16:23
Re: Aggregating by unique values 📎 Lee Hachadoorian 17:24
Re: Using count on a join, group by required? Rob Sargent 18:14

Dec. 15, 2010

Thread Author Time
How to convert string to integer venkat 10:23
Re: How to convert string to integer Szymon Guz 10:27
Re: [SQL] How to convert string to integer Pavel Stehule 10:27
Re: [SQL] How to convert string to integer Viktor Bojović 10:37
Database consistency after a power shortage Alberto 15:12

Dec. 16, 2010

Thread Author Time
Translate Function PL/pgSQL to SQL92 serviciotdf 01:22
Re: Database consistency after a power shortage Scott Marlowe 07:38
Re: Database consistency after a power shortage Samuel Gendler 07:58
Re: Translate Function PL/pgSQL to SQL92 Filip Rembiałkowski 11:17
Re: Database consistency after a power shortage Jean-David Beyer 14:38
UPDATE in a specific order Luiz K. Matsumura 14:57
Re: UPDATE in a specific order Jasen Betts 19:58
Create/update trigger auto-populate fields. Chris Ruprecht 20:42

Dec. 17, 2010

Thread Author Time
Full Text search differences from 8.3 to 8.4.6 Achilleas Mantzios 10:19
Re: Translate Function PL/pgSQL to SQL92 serviciotdf 15:26
Help with Function in plpgsql acurtis416 16:58
Re: UPDATE in a specific order Luiz K. Matsumura 19:01

Dec. 18, 2010

Thread Author Time
Table name as a variable in SELECT query Andrey Fokin 12:46
Re: Table name as a variable in SELECT query Andreas Kretschmer 14:01

Dec. 21, 2010

Thread Author Time
linux. ossp-uuid Николай Ижиков 08:31
Re: linux. ossp-uuid Trinath Somanchi 11:06
converting type and function in postgresql ? Amar Dhole 11:33
data import Viktor Bojović 11:34
Re: data import Pavel Stehule 11:36
Re: converting type and function in postgresql ? Trinath Somanchi 11:58
Re: data import Achilleas Mantzios 12:04
Re: data import Chris Ruprecht 16:18

Dec. 22, 2010

Thread Author Time
Re: linux. ossp-uuid Basil Bourque 02:00

Dec. 23, 2010

Thread Author Time
Issue while using PostgreSql 8.4. Atul Kumar 08:31
Re: Issue while using PostgreSql 8.4. Kevin Grittner 15:23

Dec. 29, 2010

Thread Author Time
Re: data import Viktor Bojović 01:45

Dec. 30, 2010

Thread Author Time
create function problem Gary Stainburn 16:26
Re: create function problem Pavel Stehule 17:35
Re: create function problem Adrian Klaver 17:47
Re: create function problem Gary Stainburn 20:16
create role Tony Capobianco 22:14
Re: create role Adrian Klaver 22:23

Dec. 31, 2010

Thread Author Time
Re: create role tcapobianco 16:22
Re: create role Adrian Klaver 16:34
Re: create role Adrian Klaver 17:05

Jan. 4, 2011

Thread Author Time
"<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? Bryce Nesbitt 22:29
Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? Michael Glaesemann 22:32
Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? Bryce Nesbitt 22:47
Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? bricklen 23:03

Jan. 5, 2011

Thread Author Time
foreign key question Gary Stainburn 09:53
Re: foreign key question Gary Stainburn 10:40
return records with more than one occurrences Tarsis Lima 14:18
pattern matching with dates? Good, Thomas 19:39
Re: foreign key question Jasen Betts 19:54

Jan. 6, 2011

Thread Author Time
explicit casts Iuri Sampaio 00:24
Re: explicit casts Iuri Sampaio 01:22
Re: explicit casts Adrian Klaver 02:20
Re: explicit casts Adrian Klaver 02:33

Jan. 7, 2011

Thread Author Time
Re: return records with more than one occurrences Jasmin Dizdarevic 10:07
Re: pattern matching with dates? Samuel Gendler 10:44
Re: return records with more than one occurrences Oliveiros d'Azevedo Cristina 11:04
Re: pattern matching with dates? Susanne Ebrecht 12:39
Re: pattern matching with dates? pasman pasmański 14:15
Re: pattern matching with dates? Richard Huxton 16:09

Jan. 8, 2011

Thread Author Time
Re: return records with more than one occurrences Russell Galyon 04:48
Re: pattern matching with dates? Jasen Betts 10:22

Jan. 11, 2011

Thread Author Time
Find NOT NULLs in a group of 20 columns gvim 02:14
Re: Find NOT NULLs in a group of 20 columns Tom Lane 02:45
help needs in converting db2 function in postgresql. Amar Dhole 12:17
Getting top 2 by Category Ozer, Pam 19:00
Re: Getting top 2 by Category Peter Steinheuser 19:51
Re: Getting top 2 by Category Ozer, Pam 19:53
Re: Getting top 2 by Category msi77 20:00
Re: help needs in converting db2 function in postgresql. Filip Rembiałkowski 20:11

Jan. 12, 2011

Thread Author Time
Re: help needs in converting db2 function in postgresql. Amar Dhole 08:18
Implement PostgreSQL full text search - 09:14
INSERT/UPDATE .. RETURNING Protasov Vladimir 12:41
joining one record according to max value George Francis 22:30
Re: joining one record according to max value George Francis 22:39
Re: joining one record according to max value Jasmin Dizdarevic 22:49
Re: joining one record according to max value George Francis 22:53
Re: joining one record according to max value Jasmin Dizdarevic 23:05
Re: joining one record according to max value George Francis 23:38

Jan. 14, 2011

Thread Author Time
why does seq scan instead of index scan 中川　誠貴 08:58
Re: why does seq scan instead of index scan Tom Lane 17:56

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

Browse Archives

Prev | Next