pgsql-sql since 2006-06-18 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

June 18, 2006

Thread Author Time
Re: any additional date_time functions? Bruno Wolff III 09:54
join on next row Sim Zacks 11:14
Re: any additional date_time functions? Richard Broersma Jr 15:28
Re: concurrency problem Aaron Bono 21:24

June 19, 2006

Thread Author Time
Re: concurrency problem Andrew Sullivan 15:28
Re: keeping last 30 entries of a log table Jeff Frost 16:16
Re: keeping last 30 entries of a log table Daniel CAUNE 17:13

June 20, 2006

Thread Author Time
Doubt in stored procedure satheesh Gnanasekaran 06:25
Re: keeping last 30 entries of a log table Dirk Jagdmann 13:48
Re: keeping last 30 entries of a log table Jeff Frost 14:12
unknown sqlstate code 📎 Juliann Meyer 18:44
Problema com função UPPER Eduardo Giovany Schweigert 19:09
Re: unknown sqlstate code Tom Lane 20:16
Re: [SQL] Problema com função UPPER Hélder M. Vieira 21:54

June 21, 2006

Thread Author Time
Displaying first, last, count columns Worky Workerson 14:55
How to get a result in one row virgi 15:06
Re: Displaying first, last, count columns Aaron Bono 15:10
Re: Displaying first, last, count columns Frank Bax 15:21
Re: keeping last 30 entries of a log table Ben K. 17:49
Re: keeping last 30 entries of a log table Jeff Frost 17:57
Re: How to get a result in one row Frank Bax 18:06
Re: How to get a result in one row Richard Broersma Jr 18:24
Re: How to get a result in one row Frank Bax 19:15

June 22, 2006

Thread Author Time
Re: join on next row Justin Lintz 06:25
Start up question about triggers Forums @ Existanze 09:19
Re: Start up question about triggers Forums @ Existanze 13:09
Re: Doubt in stored procedure Richard Broersma Jr 14:26
Re: Doubt in stored procedure Richard Broersma Jr 14:41
Re: Date ranges + DOW select question Aaron Bono 15:25
Re: join on next row Aaron Bono 15:43
Re: Start up question about triggers Aaron Bono 16:03
Re: Start up question about triggers Forums @ Existanze 16:58

June 23, 2006

Thread Author Time
Fwd: Start up question about triggers Aaron Bono 03:17
Re: Fwd: Start up question about triggers Richard Broersma Jr 05:09
Re: Fwd: Start up question about triggers Forums @ Existanze 07:15
Re: Fwd: Start up question about triggers George Weaver 12:37
Re: Fwd: Start up question about triggers Richard Broersma Jr 14:27
Re: Fwd: Start up question about triggers Forums @ Existanze 15:48
Re: Fwd: Start up question about triggers Forums @ Existanze 17:28
Re: Fwd: Start up question about triggers Andrew Sullivan 17:35
Re: Fwd: Start up question about triggers Tom Lane 17:48

June 24, 2006

Thread Author Time
Re: Fwd: Start up question about triggers Aaron Bono 03:29

June 26, 2006

Thread Author Time
Re: Fwd: Start up question about triggers Andrew Sullivan 10:43
join two tables with sharing some columns between two filippo 13:39
Re: Fwd: Start up question about triggers Forums @ Existanze 13:59
Re: Fwd: Start up question about triggers Richard Broersma Jr 14:15
Re: Fwd: Start up question about triggers Andrew Sullivan 14:43
Re: Fwd: Start up question about triggers Scott Marlowe 15:38
Re: Fwd: Start up question about triggers Andrew Sullivan 18:24
avg(interval) Jeremiah Elliott 21:22
Re: avg(interval) Tom Lane 21:37
Re: avg(interval) Joe 22:12
Problem w/ Join... Using (...) Syntax operationsengineer1 23:03
Re: Problem w/ Join... Using (...) Syntax Alvaro Herrera 23:16
permissions from system catalogs Kyle Bateman 23:30

June 27, 2006

Thread Author Time
Re: avg(interval) Aaron Bono 00:53
Re: permissions from system catalogs Tom Lane 01:28
Re: permissions from system catalogs Michael Fuhr 01:36
Re: avg(interval) Erik Jones 02:49
Re: avg(interval) Joe 03:20
Re: Fwd: Start up question about triggers Forums @ Existanze 08:16
Re: Fwd: Start up question about triggers Andrew Sullivan 11:39
Re: Fwd: Start up question about triggers Forums @ Existanze 11:48
Re: Fwd: Start up question about triggers Joe 12:14
Joins between int and int[] Rodrigo Sakai 14:02
Schema management tool Kyle Bateman 15:22
Re: Schema management tool Josh Berkus 16:26
Re: Fwd: Start up question about triggers Andrew Sullivan 18:37
Re: Fwd: Start up question about triggers Andrew Sullivan 18:38
graph plottin engines compatible with postgres Parang Saraf 20:10
Re: Fwd: Start up question about triggers Richard Broersma Jr 20:13
Re: Fwd: Start up question about triggers Alvaro Herrera 20:25

June 28, 2006

Thread Author Time
i need solution to this problem Penchalaiah P. 05:45
Re: i need solution to this problem Ragnar 07:34
Re: i need solution to this problem Richard Broersma Jr 11:43
RES: Joins between int and int[] Rodrigo Sakai 14:31
Re: RES: Joins between int and int[] Achilleus Mantzios 15:17
unique values of profile in the whole system deb.vanni 15:56
"CASE" is not a variable Keith Worthington 16:00
generate_series with left join Pedro B. 16:00
Re: "CASE" is not a variable Tom Lane 16:16
Re: "CASE" is not a variable Keith Worthington 17:34
Re: "CASE" is not a variable Bricklen Anderson 17:48
Re: generate_series with left join Aaron Bono 18:34
Re: generate_series with left join Pedro B. 19:26
Re: generate_series with left join Aaron Bono 20:10
Re: generate_series with left join Aaron Bono 20:16
Re: generate_series with left join Pedro B. 20:28

June 29, 2006

Thread Author Time
SELECT Aggregate Phillip Smith 04:23
Re: SELECT Aggregate Aaron Bono 04:57
Re: SELECT Aggregate Richard Broersma Jr 05:23
Re: SELECT Aggregate Richard Broersma Jr 05:39
can any one solve this problem Penchalaiah P. 06:28
Re: "CASE" is not a variable Patrick Jacquot 08:00
Data Entry and Query forms Anthony Kinyage 13:40
Re: Data Entry and Query forms Markus Schaber 13:50
Re: SELECT Aggregate Aaron Bono 15:25
Re: can any one solve this problem Aaron Bono 15:30
Re: Data Entry and Query forms Aaron Bono 15:41
Re: Data Entry and Query forms Joe 15:57
Re: Data Entry and Query forms operationsengineer1 18:02
Using In Clause For a Large Text Matching Query Jason Farmer 20:00
Documentation Generator for pl/pgsql Daniel Caune 20:07
Re: Using In Clause For a Large Text Matching Query Richard Broersma Jr 20:49
Re: Documentation Generator for pl/pgsql Jonah H. Harris 21:03
SQL (Venn diagram type of logic) Vinnie Ma 21:42

June 30, 2006

Thread Author Time
Re: Using In Clause For a Large Text Matching Query Richard Broersma Jr 00:17
Re: SELECT Aggregate Phillip Smith 00:37
Re: SELECT Aggregate Richard Broersma Jr 00:51
Re: SELECT Aggregate Phillip Smith 02:55
Re: SELECT Aggregate Richard Broersma Jr 04:48
Re: Data Entry and Query forms Jure Kodzoman 09:51
Re: Using In Clause For a Large Text Matching Query Jason Farmer 12:31
Views and query planner Mario Splivalo 12:35
Re: Views and query planner Michael Glaesemann 12:47
Re: Views and query planner Mario Splivalo 13:23
Re: Views and query planner Markus Schaber 14:13
Alternative to Select in table check constraint Richard Broersma Jr 21:55
Re: How To Exclude True Values Richard Broersma Jr 22:49

July 1, 2006

Thread Author Time
Re: Alternative to Select in table check constraint Michael Glaesemann 00:27
Re: Alternative to Select in table check constraint Richard Broersma Jr 01:41
Re: Alternative to Select in table check constraint Tom Lane 04:11
Re: Alternative to Select in table check constraint Richard Broersma Jr 05:10
Re: [SQL] Doubt in stored procedure Jim C. Nasby 05:50
Re: Alternative to Select in table check constraint Erik Jones 12:54
Constraint UNIQUE on a column not case sensitive Daniel CAUNE 13:47
Re: Constraint UNIQUE on a column not case sensitive Michael Glaesemann 14:01
Re: Constraint UNIQUE on a column not case sensitive Jorge Godoy 14:04
Re: Constraint UNIQUE on a column not case sensitive Daniel CAUNE 15:48
Re: Alternative to Select in table check constraint Rod Taylor 17:06
Re: Alternative to Select in table check constraint Aaron Bono 20:36
Left join? Carlos H. Reimer 21:21
Re: Left join? Richard Broersma Jr 21:44

July 2, 2006

Thread Author Time
RES: Left join? Carlos H. Reimer 12:52
Can't drop table Hima Surapaneni 22:30

July 3, 2006

Thread Author Time
Re: Alternative to Select in table check constraint Richard Broersma Jr 01:50
Re: Alternative to Select in table check constraint Richard Broersma Jr 01:52
Re: join two tables with sharing some columns between two Phillip Smith 02:16
Re: Can't drop table Richard Broersma Jr 02:30
Re: Can't drop table Tom Lane 03:23
hi i need to connect database from my system to another system Penchalaiah P. 10:13
Re: graph plottin engines compatible with postgres Patrick Jacquot 10:31
Re: hi i need to connect database from my system to another system Richard Broersma Jr 11:58
Re: Fwd: Start up question about triggers Forums @ Existanze 12:20
Re: hi i need to connect database from my system to another system Richard Broersma Jr 12:26
Re: hi i need to connect database from my system to another Penchalaiah P. 12:46
Re: hi i need to connect database from my system to another Richard Broersma Jr 13:09
Local variable and column name conflict Daniel Caune 15:34
Re: Local variable and column name conflict Tom Lane 15:37
Re: join two tables with sharing some columns between two Thomas Beutin 15:54
Re: unique values of profile in the whole system Bruno Wolff III 16:06

July 4, 2006

Thread Author Time
i have a problem of privilages Penchalaiah P. 10:05
Re: i have a problem of privilages MJ Santhosh 12:17
Re: i have a problem of privilages Penchalaiah P. 12:23
Re: i have a problem of privilages MJ Santhosh 12:31
Re: i have a problem of privilages Richard Broersma Jr 14:51
Re: i have a problem of privilages Andreas Kretschmer 15:30
Re: SQL (Venn diagram type of logic) Aaron Bono 16:55
Null attributes Rodrigo Sakai 16:59

July 5, 2006

Thread Author Time
Foreign Key: what value? Davi Leal 15:19
Re: Foreign Key: what value? A. Kretschmer 15:34
Problem with array subscripts in plpgsql trigger function Erik Jones 16:52
Re: Problem with array subscripts in plpgsql trigger function Aaron Bono 17:36
Re: Problem with array subscripts in plpgsql trigger function Erik Jones 17:42
Re: Problem with array subscripts in plpgsql trigger function Aaron Bono 17:56
Re: "CASE" is not a variable Keith Worthington 18:08
Re: Problem with array subscripts in plpgsql trigger function Erik Jones 18:10
Re: Foreign Key: what value? -- currval() Davi Leal 22:07

July 6, 2006

Thread Author Time
week ending Keith Worthington 04:19
Re: week ending Rodrigo De Leon 07:00
Alternative to serial primary key David Clarke 10:16
Re: Alternative to serial primary key Andrew Sullivan 10:44
Re: Alternative to serial primary key Markus Schaber 10:46
Re: Alternative to serial primary key David Clarke 11:06
Re: Alternative to serial primary key Markus Schaber 11:10
Re: Alternative to serial primary key Andrew Sullivan 11:12
Re: Alternative to serial primary key Markus Schaber 11:28
Re: Alternative to serial primary key David Clarke 11:32
Re: Alternative to serial primary key Chris Browne 12:28
Re: Alternative to serial primary key Andrew Sullivan 12:50
Re: Alternative to serial primary key Andrew Sullivan 12:51
Re: Alternative to serial primary key Scott Marlowe 14:41
Re: week ending Aaron Bono 15:49
Re: Alternative to serial primary key Aaron Bono 16:02
Re: Alternative to serial primary key operationsengineer1 18:39
Re: Foreign Key: what value? operationsengineer1 18:46
Re: Foreign Key: what value? Aaron Bono 19:32
Re: Alternative to serial primary key David Clarke 20:30
Re: Alternative to serial primary key D'Arcy J.M. Cain 21:18
Re: Alternative to serial primary key Aaron Bono 21:43
Re: Alternative to serial primary key Sander Steffann 21:45
Re: Alternative to serial primary key Scott Marlowe 21:50
Re: Alternative to serial primary key Scott Marlowe 21:51

July 7, 2006

Thread Author Time
Re: Alternative to serial primary key operationsengineer1 05:25
Re: Alternative to serial primary key Aaron Bono 05:51
Select CASE Concatenation Phillip Smith 06:47
Select Maths Phillip Smith 06:53
Re: Alternative to serial primary key David Clarke 07:37
Re: Alternative to serial primary key David Clarke 08:07
Re: Select Maths Rodrigo De Leon 08:20

Browse Archives

Prev | Next