pgsql-sql before 2011-01-28 02:41

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

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

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

Browse Archives

Prev | Next